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. Thanks for any help.
Go back