Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BEGIN-END Transaction question
Message
From
19/06/2004 10:55:19
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
19/06/2004 10:45:36
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00915326
Message ID:
00915337
Views:
12
This message has been marked as the solution to the initial question of the thread.
>Hilmar,
>Yes, I would be rlock()'ing the account record.
>
>Currently my app only has error handling to the point of tracking the errors to a table.
>
>It appears I will need to expand my error handling to handle update conflicts, something I have worried about anyway. I have found a thread by searching for "quantity on hand". Just started reading it. Will see if that offers details. Also have some white papers on multi-user programming and am re-reading them as well.
>
>Thanks again,
>John

IIRC, a transaction will lock records modified during the transaction automatically. But I don't know how error handling will work in this case, and explicit locking might very well be the simplest route.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform