Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anil Sharma
  Where is Anil Sharma?
 ludhiana
 India
 Anil Sharma
 To: Pete Huish
  
 Sydney
 
 Pete Huish
 Tags
Subject: RE: select into cursor
Thread ID: 331237 Message ID: 331242 # Views: 48 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Wednesday, December 28, 2011 6:01:00 AM         
   


> I have a select statement that works just fine when I select f1, f2, f3 from table into array a1 but if I do the select into a cursor then it does not produce the cursor.
>
> What have I missed?
>
>
> thanks,
>
> pete

If your table is in buffer mode than you need to something linke

select * from yourtable WITH (buffering = .t.)

Anil


Accounting Software

Web Development

Accounting, Inventory, Hotel Management, Restaurant Kot Billing, MLM, Excise Accounting and much much more!.
My Blog

ENTIRE THREAD

select into cursor Posted by Pete Huish @ 12/28/2011 5:04:45 AM
RE: select into cursor Posted by Don Higgins @ 12/28/2011 5:09:12 AM
RE: select into cursor Posted by Pete Huish @ 12/28/2011 6:30:54 AM
RE: select into cursor Posted by Jun Tangunan @ 12/28/2011 7:10:00 AM
RE: select into cursor Posted by tushar @ 12/28/2011 7:25:09 AM
RE: select into cursor Posted by Jun Tangunan @ 12/28/2011 7:31:51 AM
RE: select into cursor Posted by Koen Piller @ 12/28/2011 9:51:47 AM
RE: select into cursor Posted by Anil Sharma @ 12/28/2011 6:01:00 AM