Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Coding for remote (SQL Server) and local data access
Message
De
08/05/2001 15:19:11
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Coding for remote (SQL Server) and local data access
Divers
Thread ID:
00504949
Message ID:
00504949
Vues:
79
Hello,

I need a quick "pointer in the right direction" before I head off down the wrong path.

I need to access remote data from SQL Server and be able to work with a copy of this data when working standalone. Here is my guess at the steps in doing this (assume there is one table in the database named table1):

1. Upsize the current FoxPro database to SQL Server. This results in "table1" (a view of the remote data) and "table1_local", a local foxpro table as before the upsize.

2. If the user wants to work with remote data, do a "use table1" and do tableupdates, tablereverts, etc. to manipulate the data.

3. If the user wants to work locally, copy the remote data to an empty "table1_local" and then create a view of this data which can be treated the same as the view of the remote data.

I am obviously trying to keep the bulk of the code from knowing which view it is working with.

Thanks for any suggestions,
Pat
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform