From: mike castillo
Joo Seng Road, Singapore
To: Joriveek Joriveek
Visual FoxPro 7
General VFP Topics
Tuesday, April 08, 2003 2:56:58 PM
This message was rated by:
> 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
> ...but still i did not get why recno() is not working.
> > 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.
Posted by Joriveek Joriveek @ 4/8/2003 11:02:21 AM
Posted by Joriveek Joriveek @ 4/8/2003 11:14:12 AM
Posted by mike castillo @ 4/8/2003 2:56:58 PM