Check
How to make SQL Pass-Through cursor updatable FAQ #8153
>I would like to learn a technique (efficient and fast) to update a table from a cursor. The application does not use views but instead loads records from a table (VFP or SQL Server) into a cursor. A number of records in this cursor are updated all at once. Then I need to update the underlying table from this cursor.
>
>How do you suggest doing it?
>
>Thank you in advance.
--sb--