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