>Hi,
>
>I thought that all changes to the remote table are done via TABLEUPDATE() on the cursor created with CursorAdapter. But something does not work. I am trying to delete a record from a table (SQL Server). Here is what I do:
>
>

>select CA_ALIAS    && alias assigned to the CA cursor
>delete
>
>if !tableupdate(0,.T.)
>   *--- show error
>endif 
>

>
>The TableUpdate gives me error:
>
>

>Unable to locate target record in ADODB.Recordset
>

>
>What am I missing? TIA.

Are you trying to delete newly added record or one of the oldest records? Did you trace what is the exact command send to SQL Server?