>>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.
I see that I have specified KeyFieldList and Tables. But I have not set a value into WhereType property at all. I am looking at the help and see that I have 4 choices. So I will try them one at a time :). Thank you.
"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