Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with Postgres ODBC driver
Message
From
11/08/2010 09:55:22
 
 
To
10/08/2010 11:07:22
Calvin Smith
Wayne Reaves Computer Systems
Macon, Georgia, United States
General information
Forum:
Visual FoxPro
Category:
Third party products
Miscellaneous
Thread ID:
01475953
Message ID:
01476183
Views:
47
>Naomi,
>Thanks for your reply. Actually I am not using VFP tables in this one. I am using remote views on SQLServer and Postgres. It seemed like a good idea when I started but has turned into a nightmare. I think I am going to switch and use SQL Passthrough.

This should work - but again: "investing" some time (less than 1H more for the specific problem, some more reading while you encounter CA quirks) into learning about Cursoradapters will give you a payoff of already existing hooks in the process started with tableupdate for instance. For *me* a much better place to debug than at each server side - and a common interface already set up which only need to be customized for some backend quirks is an added bonus if you cannot fall back on a already existing class library for SPT.

OTOH: your code reads as if you have no problem whatever with the performance of moving the data -
leaving me here to guess that you have only small amounts of data. If that assumption is false,
and you are moving to SPT because you heard it was faster, I'd recommend recoding your datashuffling and use Cursoradapter.

my 0.05 EUR (been there, done that <g>)

thomas
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform