Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ERROR: multi-user environment UPDATE issues...
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
ERROR: multi-user environment UPDATE issues...
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01125930
Message ID:
01125930
Views:
52
I'm hoping somebody can shine some light on an issue that I have.

I have a contact management system that is used by several employees. Generally anywhere from 1 to 6 people. Every now and again a user claims that information they had entered had dissappeared. Now, after said employees have been alerted and are keeping very good watch for anything out of the ordinary I have found that these issues only occur when two people save their changes at the same time. In fact.... it often flips the records about:

Employee A saves the contact: "Sam Junior"
Employee B saves the contact: "George Foreman"

Result: two records of "George Foreman" and no Sam Junior to be found...

I had been using buffering on the table earlier but it was necessary to move away from that and all contact data is now held in a cursor. The master table is updated when the user clicks the save button. No tableupdate() is issued. The master contact table resides on a network drive accessible by all employees.

Please, any insights, comments, suggestions on this issue would be greatly appreciated. I have been developing in VFP now for 4 years and have never seen anything like this before.
+=================================+
|John McCarthy, Programmer, MEG
+=================================+
Next
Reply
Map
View

Click here to load this message in the networking platform