Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
TABLEUPDATE() Fails
Message
De
11/10/2016 11:42:13
 
 
À
20/09/2016 20:41:37
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01641157
Message ID:
01641829
Vues:
107
A little late, but thanks to all who responded.........

I was finally able to isolate the actions which caused the TABLEUPDATE failure.

During processing the program would DELETE some records in the cursor. It would do some more processing and then issue a RECALL ALL before doing the TABLEUPDATE.
(Please don't ask why....it's not relevant to this discussion)

Apparantly the RECALLed records are seen as requiring an INSERT. But because the record was only DELETED in VFP it remained in MySQL. When TABLEUPDATE tried to do the INSERT it generated a DUPLICATE KEY error.

I was able to circumvent this by trapping for the failure, examining the error message and, when appropriate, issuing a DELETE on the backend, and then resuming the processing.

Again.....Thanks to all for your responses.

.........Rich
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform