Pull the records you want into a local cursor. Then using cusorsetprop(), set the cursor properties to make it updateable. (see Help)

ie...
sqlexec(lnHandle,SQLString,'thecursor')
select thecursor && Not needed unless you go somewhere else.

cursorsetprop("Tables","dbo.Table")
cursorsetprop("UpdateNameList","tableno dbo.table.tableno")
cursorsetprop("KeyFieldList",'tableno')
cursorsetprop("UpdatableFieldList","tableno")
cursorsetprop("SendUpdates",.T.)

Do your work here...

tableupdate(.T.,.T.)
use in thecursor

This will send all your changes to the remote server like a view only faster.

The syntax varies from backend to backend.

HTH