Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speed up opening of forms
Message
 
To
13/10/1998 22:54:02
Jim Underwood
Apollo Information Systems, Inc.
Houston, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00146146
Message ID:
00146479
Views:
32
Jim,
Sure, no problem....

Recent is with VMF 2, code written March '98 in VFP5

Buffering: Didn't matter. We're talking about a simple USE MyTable not getting the latest data from the network.

Semaphore locking: This wasn't clear - sorry.

We are using a semaphore locking technique in which users lock a 'group' of records. The group can vary from a single record to 5-6000 records, so record locks weren't feasible. We have a table that stores the appropriate lock. It is never buffered, and is used, a record locked and updated (or added) and then closed, in exactly the same manner as our Unique IDs are. The reasoning behind this is that all records with a certain 'status' need to be available to a single user for a given period of time.

What we found, was that if the semaphore table was loaded into the default data session that it was nearly impossible for workstation 1 to see a lock put on in the last 5 minutes by workstation 2. We checked a LOT of 'refresh' values, and finally found we needed to NOT load the table initially.

We then started looking at OTHER data and found the same problem.

Hope this is clearer

Barbara


>Hi Barbara,
>
>>>... but the form will not show recent changes made by other users. We ended up disabling this feature in Visual MaxFrame because we had so much trouble with file updates in our semaphore locking system. and other areas.<<
>
>Would you mind expanding on this please?
>
>What do you mean by recent?
>What kind of buffering were you using?
>What do you mean my "semaphore locking system"? Is this something VFP does natively, or a custom design?
>
>TIA,
>jmu
Barbara Paltiel, Paltiel Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform