Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Andy Kramek
  Where is Andy Kramek?
 Hot Springs Village
 Arkansas - United States
 Andy Kramek
 To: Anders Wennerwik
  Where is Anders Wennerwik?
 Ross-on-Wye
 United Kingdom
 Anders Wennerwik
 Tags
Subject: RE: remote view
Thread ID: 78544 Message ID: 78547 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Wednesday, October 05, 2005 12:40:38 PM         
   


> Hello,
>
> Is there a way to have a view where you on startup of a form only loads say the first couple of thousand records but then continues to add records in the background?
> Note, Yes I need to have ALL records on the form at some point... ;-)


You can try adjusting the background fetch property on the connection (CursorSetProp( 'Fetchsize', n )). The default is 100 records at a time. Good luck!

Regards
Andy Kramek
Microsoft MVP (Visual FoxPro)
Tightline Computers Inc, Akron Ohio, USA

ENTIRE THREAD

remote view Posted by Anders Wennerwik @ 10/5/2005 12:33:48 PM
RE: remote view Posted by Andy Kramek @ 10/5/2005 12:40:38 PM
RE: remote view Posted by Borislav Borissov @ 10/5/2005 12:51:48 PM