>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.
Check:
WhereType,
KeyFieldList,
Tables
properties of the CA.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.