Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement