Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to 'play' with the way remote views fetch data?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00616337
Message ID:
00616342
Views:
27
>>Hi
>>If i create a remote view to an ODBC data source, how can i play with the way it fetches the data from the data source? Is there a command that lets me manage the quantity of records fetched, or just that can force a requery of the data ( in case it changed in the meantime? )
>>
>>TIA
>>Jaime
>
>There is a FetchSize property in the view that tells VFP how many records to fetch at a time. Other than that I don't know of any other controls for this.

I saw this one, but it's not enough. I'm rather looking for a way to do a requery of some data ( based on the SQL Query that creates the view...)
Why do programs stop working correctly as soon as you leave the Fox?
Previous
Reply
Map
View

Click here to load this message in the networking platform