General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>it seems to me you are doing double work for no reason
>>once updating the view and then committing the changes you may want to look at SQL Passtrough (SQLEXEC) for this specific update
>
>... I don't understand where's the double work. Can you be a little more specific, please? I never used SQL Passthrough. Thanks.
>
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)
Arnon
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