Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote Views
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00709588
Message ID:
00709600
Views:
15
>Is there any method of changing the way remote views are recreated? Currently when recreating remote views, each view seems to be generating an SQL command of "SELECT * FROM table" which on large tables and on a WAN can take a long time (several minutes).

The idea behind a Client/Server architecture (and hence Remote Views) is not to query the whole table (SELECT * FROM Table) but only bring a subset through the wire (especially in a WAN). With RVs you do that through parameters (parameterized views). Something like: SELECT * FROM Table WHERE City = ?cCity. If you initialize: cCity="Granville" before a Requery() then you only get the matching records.


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform