Loop through table

[brindlogcool]

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 .

[swuehl]

Try using Recno()=$(i) in your where clause. And I think FieldValue() indexing starts with 1, please recheck.

Regards,

Stefan

[brindlogcool]

Thanks Stefan, its working now. You are right after using 1 as the index value . it is working fine now.