Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
One remote view, many identical source tables: how to do
Message
De
04/06/2002 17:54:15
Randy Witt
Diamond Vogel Paints
Orange City, Iowa, États-Unis
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00664726
Message ID:
00664747
Vues:
17
I will try out the information which you provided. Thanks.

I have also discovered that I was probably going about things incorrectly. I had set up 16 different named connections, one for each of the 16 databases. I had set up a single remote view. Apparently, once a remote view is set up, it retains the connection name. I tried (unsuccessfully) to get the remote view to accept a different connection. Instead, I can use DBSETPROP to change the details of the named connection to which the view is linked. Before I attempt to open the view, I simply pass whichever connection string is appropriate for that company division, to DBSETPROP. That seems to achieve what I needed.

Best wishes,
Randy
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform