I found a solution to my problem in the following way....it's working now...sorry to bother you! Thanx...

FOR i = 1 TO lcNumberOfRecords
GOTO i IN mytable
* get the records
* for example
messagebox(mytable.customer_name)
ENDFOR

...but still i did not get why recno() is not working.

Thanks
J.

>
> Hi,
>
> I want to retrieve each and every record from a table with a primary key in it from my SQL Command as follows:
>
> ----------------------------------
> for i = 1 to lcNumberOfRecords
> SELECT customer_name FROM employees INTO CURSOR mytable WHERE RECNO() = i
> messagebox(mytable.customer_name)
> endfor
> ---------------------
> But it's not working thought there is nothing wrong with the syntax! Can anyone give me a hand?
>
> Thanx
> J.