Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TABLEUPDATE() Fails
Message
From
11/10/2016 11:42:13
 
 
To
20/09/2016 20:41:37
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01641157
Message ID:
01641829
Views:
106
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
Previous
Reply
Map
View

Click here to load this message in the networking platform