Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote views vs disconnected recorsets
Message
 
À
18/12/2000 18:46:35
Christian Cote
Les Logiciels Onoma Inc.
Longueuil, Québec, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00454869
Message ID:
00454872
Vues:
25
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform