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
Eric Kleeman - EDS Consulting Services
MCP Visual FoxPro
MCSD C#.NET
Hua Hin Thailand
Los Angeles California