General information
Category:
Third party products
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only