Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote views vs disconnected recorsets
Message
 
To
18/12/2000 18:46:35
Christian Cote
Les Logiciels Onoma Inc.
Longueuil, Quebec, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00454869
Message ID:
00454872
Views:
23
>HI,
>I will have to implement one of these technologie pretty soon and I would like to know which one you think would be the best choice. I have an app in VFP that has 30-35 local views, 5-10 remote views and I need to go offline with some of the views (either local and remote).
>
>I use ADO a lot in VB but not very much in VFP since views were good enough and they are native to VFP. Are recordsets in VFP slower than views ?
>
>Thank you for your help,
>Christian Cote

I am sorry, but I cannot answer your question about ADO vs. remote views? Is your backend SQL Server? If so, you may want to consider using MSDE (SQL Desktop Engine) as the local data store. Your VFP app can access the SQL Server data when the app is attached to the server via one set of views, and access the MSDE data via another set of views when the app is disconnected from the server. Replication can be used to synchronize the data.
Chris McCandless
Red Sky Software
Previous
Reply
Map
View

Click here to load this message in the networking platform