See Re: SQL Tableupdate with remote view not working Thread #592857 Message #592912

That sample code is used on a cursor created using SQLEXEC(), but you can use DBSETPROP() function to set those values for your remote view.

>I am trying to learn how to update a SQL Table using remote views - but it does not work.
>
>I implemented the following test code:
>
>

>
>SET MULTILOCKS ON  && Must be on for table buffering
>OPEN DATABASE certification_information
>USE driver_info IN 0 && Remote view pointing to SQL table
>SELECT driver_info
>= CURSORSETPROP('Buffering', 5, 'driver_info' )  && Enable table buffering
>
>BROWSE
>REPLACE lastname WITH [test]
>
>
>lv_result = TABLEUPDATE(.T.)  && Commits changes
>? lv_result
>

>
>Which runs fine (TABLEUPDATE returns a .T.), except that it does not update the SQL table.
>
>Thanks in advance for your help!