>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.
Dmitry,
There are usual ways and less usual ways. Usual ways 'do' it but not fast (well 'fast' is a relative thing). Fast ways are generally less used because it's harder to code for them.
For example you can make a cursor updatable by just setting a few properties, set the cursor to table buffered one and call a single tableupdate. It works but under the hood it sends the updates row by row, meaning you have many update/insert calls.
For an efficient and fast way:
-Add a column to cursor marking new and modified (GetNextModified)
-Bulk load to server temp table (or if you have option use openrowset())
-Create a single update and a single insert command and execute
Cetin