Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
UPDATE on remote view is very slow
Message
From
23/02/1999 11:03:07
 
 
To
23/02/1999 10:55:35
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00190273
Message ID:
00190456
Views:
14
>you are spending time updating your cursor and then spending time commiting the changes while with SQL passthrough you would be sending the updates directly
>(depending on the settings of your connection)

Ok. So, I am using SQL passthrough to update the Access table. This would use a SQLEXEC(..., "UPDATE bla-bla", ...), right? Would this still use my relation between my dbf and the remote view? If not, how does it know to take the updated data from the right records of my dbf?

Can I UPDATE a cursor and not commit the changes? If yes, how?

Am I completly stupid? :) If yes, just tell me where to RTFM! :)

Vlad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform