>>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?
I was trying to delete newly added record. And I checked that the PK and Identify field/column did get the value from the SQL Server table. But I have not yet traced the command send to SQL Server. I should do that. Thanks.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham