Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is it possible to use SQLPT on local tables?
Message
De
30/08/2010 03:18:02
 
 
À
30/08/2010 03:11:38
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01479151
Message ID:
01479156
Vues:
67
>>I have two DBCs.
>>
>>First DBC contains a named connection to a Pervasive database through the corresponding DSN. The DBC contains read-only remote views (with the same name as remote tables) which I use to create reports.
>>
>>Second DBC contains local DBF tables which are daily copies of the remote views used to speed up reports.
>>
>>I am creating a program to make some corrections in the Pervasive database. It uses SQL passthrough in order not to change anything in the existing DBCs. I'd like to test the code using the second DBC. That would mean using SQL passthrough to make changes in local DBFs. Is that possible? How would you get a connection handle?
>>
>>TIA,
>>
>>Alex
>
>You can create a DSN with the VFP ODBC driver to access your DBFs through connections and test accordingly. Depending on your SQL statements, they may need changes or not to work (but that's the way it goes with any distinct engine you'll have on the other end).

Thank you very much Antonio.

Alex
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform