Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to loop through the table
For i=1 to NoOfRows('TREE1')
Load
FieldValue('PATH',0) as C1,
RowNo() as Rno
Resident TREE1 WHERE RowNo()=$(i);
Next i
But i am getting zero lines fetched .
Try using Recno()=$(i) in your where clause. And I think FieldValue() indexing starts with 1, please recheck.
Regards,
Stefan
Thanks Stefan, its working now. You are right after using 1 as the index value . it is working fine now.