Forum Discussion

kchampion's avatar
kchampion
New Contributor III
10 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
    10 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
10 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
10 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.