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

Using a view is, precisely, the easiest way to do it. Visual FoxPro takes care of the details. Note that the view creates a cursor, which can be modified.

Otherwise, I believe you would probably have to loop through the records, and program all the logic yourself - checking whether there were changes, which records are new, whether any records were deleted, and updating those changes.