Chris Forrett 30.Oct.09 10:40 AM a Web browser LC LSXLC LSX - All ReleasesWindows
Once I retrieve records into a field list how do I loop thru the data a second time - and what is the most efficient way?
I can fetch the data and use it with the following code.
While (LCCon.Fetch(fldLst) > 0)
process the data
Wend
When I try the same code again it does not pass the While test
While (LCCon.Fetch(fldLst) > 0)
another way to process the data
Wend
If I remark out the first fetch the second fetch works. I tried setting the field list to a new field list with Set fldLst = New LCFieldList right before the second fetch but that did not work either.
I am new to LC LSX so sorry for the simple question. As long as I am asking, what is the most efficient way to do this. Should I just store the data in an array on the first fetch and work with the array or use a select to get all the records for the second process. I am using Notes 8.5 and Oracle 11g.
Return to top
Go thru the data in a result set tw... (Chris Forrett 30.Oct.09)
. . 
Print this page
