Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update conflict
Message
From
01/11/1997 11:31:04
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Miscellaneous
Thread ID:
00057582
Message ID:
00057787
Views:
27
>Just a long shot.......
>In an app I inherited, which doesn't use buffering either, the clerk gets an occasional update conflict message because she/he bangs to "Save" key too hard and causes a key bounce. Trapping the key strokes immediately before the save code is executed seems to have cured the problem.

Here's more info.

After having checked the error log, I found that the error from from the delete function of the framework. After having deleted the record, I am restoring the pointers to the original records for all the tables involved for the delete (parent and relational tables). In this case, I am only restoring the pointer for the parent table as there is no relation. So, in this case, after the delete was done, I am restoring the pointer to the deleted record.

The error is occuring when I execute the GO lnOldRec, which represent the record the user wanted to delete which is in this case a deleted record as the delete command was ok.

In this case, I may put a condition to avoid restoring the pointers. However, this doesn't explain why they always have the error while I can't simulate it.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform