Dmitry,

Check How to make SQL Pass-Through cursor updatable FAQ #8153. Isn't the reason to make SPT cursor updatable so it can be used as a remote view?

>I am using SQL pass through, VFP 8 with SQL Server.
>
>I have two questions:
>
>1.To make a result set/cursor updatable, you have to manually list all fields of the table (CURSORSETPROP("UpdateNameList"...). To me it seems like a lot of work.
>
>I was wondering, is there a method/function to build the expression automatically for any table?
>
>2. After user changes the data, what is the "recommended" way of sending the changes back to the SQL Server: a) using tableupdate() b) building UPDATE expressing and sending it with SQLEXEC?
>
>Thank you in advance for any suggestions.