Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Delete from table via CursorAdapter
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01475511
Message ID:
01475515
Vues:
36
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform