>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
>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?
If it's not broken, fix it until it is.
My Blog