Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delete from table via CursorAdapter
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01475511
Message ID:
01475515
Views:
35
>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.



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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform