Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 To: Anders Wennerwik
  Where is Anders Wennerwik?
 Ross-on-Wye
 United Kingdom
 Anders Wennerwik
 Tags
Subject: RE: remote view
Thread ID: 78544 Message ID: 78550 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Wednesday, October 05, 2005 12:51:48 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... ;-)
>
> Anders




I don't know about remote views. But you may consider to use CursorAdapter for this. It is more flewxible and you have more control over it. In CA there is FetchSize property that tells how many records at a time you want to get.
If somehwere in the application you want all records you always can do GO BOTTOM to force this.

I just checked in help
Make the remote view property NodataOnLoad in DE to .t.
In Init event of the form put:
SELECT MyRemoteView
CURSORSETPROP("FetchSize",100,"MyRemoteView") && 100 records at a time
REQUERY("MyRemoteView")
...
somwhere where you want all records
SELECT MyRemoteView
GO BOTTOM && Just to be sure


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