Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pessimistic record locking question
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00465853
Message ID:
00465893
Views:
10
SET REPROCESS TO XX [seconds]

The default is 0 and VFP will display that message. If you limit the number of retyrs then VFP will simply not lock the record. Note that this command is scoped to individual datasessions so if you use private datasession forms, you need to reset it in the Load (or somewhere).

HTH.

>I am using pessimistic buffering with pessimistic record locking.
>Which means a record lock attempt occurs with the focus in any control on my form.
>
>Right now I have an ON ERROR trap to detect record locking only in my Save button which is not enough ON ERROR trapping.
>
>Do I have to put the ON ERROR trap in every single control on my form or is there a form-wide way to do it so I don't have to go into every control and add the words ON ERROR because I have multiple forms and many fields per form.
>
>I could probably switch to optimistic buffering and save me some time and coding, but the next version of this software I am working on will make all of this effort null and void so I am trying to fix "Attempting Record Lock ... Press ESC to Cancel" with as little time and effort as possible.
>
>Any suggestions? Thanks for the help.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Reply
Map
View

Click here to load this message in the networking platform