Hello,
I try to loop through a list, and wan't to have for each entry e result from a Oracle table.
the first execute works the second time not.
I read several posts but no solution.
Select or Execute ?
there is something with the sequence of the fieldlist.
.
.
.
.
Forall x In doc.d_struc
Print x
Set fldLst2 = New LCFieldList
SelectStatement = "SELECT * FROM DMADMIN.DDCT_DCT_INCLUDELIST WHERE NODE_ID='" + x + "' ORDER BY NODE_ID"
If (OraConnection2.execute (SelectStatement, fldLst2) = 0) Then
Call item.AppendToTextList( Chr(10) )
Else
While (OraConnection2.Fetch (fldLst2) > 0)
Call item.AppendToTextList( Cstr(FldLst2.Fields(3).value(0))+Chr(10) )
Wend
End If
End Forall

