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.