Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multi-User Error Handling
Message
 
To
28/10/1998 09:30:41
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00151511
Message ID:
00151756
Views:
36
>>>We are experiencing various errors when multiple users are adding records, specifically "Update Conflict" and "Uniqueness of x is violated". We are using optimistic row buffering and have an error routine that traps these errors. For the "Uniqueness" error we have coded a retry however we then get
>>>"Table buffer for alias x contains uncommitted changes.".
>>>
>>>Has anyone got any ideas as to what were doing wrong, or any suggestions of a better way to handle these errors.
>>>
>>>Thanks.
>>
>>Do you have primary tag on your table? How do you generate this key for new records?
>
>We do have the field marked as a primary tag. It appears to be giving us the error on the Append Blank ie. two people have created a record on the table with a primary key of spaces.

You could use private datasessions.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada

cmagee@metroland.com

Never mistake having a career with having a life.
Previous
Reply
Map
View

Click here to load this message in the networking platform