Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is it possible to use SQLPT on local tables?
Message
From
30/08/2010 03:18:02
 
 
To
30/08/2010 03:11:38
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01479151
Message ID:
01479156
Views:
66
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform