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.comWould you believe Far Side Lite?
More than 270 original cartoons.