Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Buffering and locking questions
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Buffering and locking questions
Miscellaneous
Thread ID:
00357538
Message ID:
00357538
Views:
48
I am using pessimistic buffering mode 2 (for record level) for my forms.

1. When I have record buffering mode 2 turned on, do I ever need to do an UNLOCK command or is locking and unlocking done automatically for me when I move to another record using SKIP, SKIP - 1, GO TOP, GO BOTTOM, or whenever I open a new window (load/run DO FORM)?

2. When I open my beginning form I am sitting at the bottom (last) record in the file. I go into Edit mode to update that record. But the record update spans several forms. When I load/run the second and third and forth forms I don't THISFORM.Release the opening form. Does that mean that the record will be locked or unlocked when I show the second, third or forth form? I read in the Programmer's Guide that the "record lock is released when you" move to another record or "activate another window".

The reason I am asking these questions is that my record lock seems to be locking more than just the current record. I have done FLOCK() and been showing table locks in some code in the forms. Once I solve the locking/unlocking problems, my multi-user networking will be working.

I know that the APPEND BLANK and REPLACE commands in my Edit burron are locking the record. But I don't know why pressing Top, Prev, Next, Bottom are also locking other records since I have not pressed the Edit button to lock the next or previous record. Thanks for the help.
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site: www.stephenkramer.com
Would you believe Far Side Lite?
More than 270 original cartoons.
Next
Reply
Map
View

Click here to load this message in the networking platform