Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Joriveek Joriveek
  Where is Joriveek Joriveek?
 
 Argentina
 Joriveek Joriveek
 Tags
Subject: recno()
Thread ID: 22065 Message ID: 22065 # Views: 28 # Ratings: 0
Version: Visual FoxPro 7 Category: General VFP Topics
Date: Tuesday, April 08, 2003 11:02:21 AM         
   



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.


COMPLETE THREAD

recno() Posted by Joriveek Joriveek @ 4/8/2003 11:02:21 AM
RE: recno() Posted by Joriveek Joriveek @ 4/8/2003 11:14:12 AM
RE: recno() Posted by mike castillo @ 4/8/2003 2:56:58 PM