Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pessimistic buffering problem!
Message
From
01/10/1998 09:49:25
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
01/10/1998 09:31:31
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00142782
Message ID:
00142793
Views:
35
>I have a formset in which one of the forms' load method has the following code:
>
>SET EXCLUS OFF
>SET REPROC TO AUTOMATIC
>ON ERROR DO ERRORFIX WITH ERROR(),MESSAGE()
>
>The formset is set to pessimistic buffering.
>
>When two users try to edit the same record through a data entry screen from the same form, the message "Record is locked - ESC to cancel locking" is displayed. When ESC is pressed, an error message called in errorfix is displayed, then the main application object is released and the program exits. I don't want this to happen. My intent is to clear the lock attempt and keep the form opened.

Just my opinion. Do not use "automatic". Have a timer, if rlock() unsuccesfull, display message and enable timer. Timer is there for checking if it can place a lock + displaying still in use while the user is waiting. If s/he navigates to another rec disable timer. Works good with pessimistic.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform