Forum Discussion

kchampion's avatar
kchampion
New Contributor III
3 months ago
Solved

SetDataCellsUsingMemberScript does not write all list items

Hello All, SetDataCellsUsingMemberScript() seems to only write the last value added to list.  I am successfully adding 14 records to the objMemberScriptValues list (I can loop through them and see ...
Extenders
Finance
  • MarcusH's avatar
    MarcusH
    3 months ago

    You need to move this line to be before the For loop starts:

    Dim objMemberScriptValues As New List(Of MemberScriptAndValue)

     

Krishna's avatar
Krishna
Valued Contributor
3 months ago

The For Loop Next should be after the End If, then it will write all the values!!!!

  • kchampion's avatar
    kchampion
    New Contributor III
    3 months ago

    Correct, it does, but it commits one row at a time, which is very inefficient.  I was looking for a way to write all the rows to the list in memory and commit them all at once to improve performance.