>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, you're marvelous. This was the very next question I wanted to ask, and you read my mind! Thanks.
One stupid question: why "dbo." ? Does that have some special meaning? And is there any way to say "all fields" rather than enumerating them?
Tom
Tom Green in Montreal