>>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