Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Soft locks and table buffering
Message
From
18/09/2002 18:15:36
Irv Adams
MSC Managed Care, Inc.
Florida, United States
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00700960
Message ID:
00702051
Views:
22
Here goes:

When someone clicks on a button, etc., associated with editing a record, we Ascan() a Globally-visible array (oGlobal.RecsCheckedOut[1000]) containing User IDs and Rec#s.

If not found, we Ains() a record into this Array and add Getenv('User_ID') or something similar and Recno(). This effectively 'checks out' the record for this User. When they 'SAVE', we Adel() the entry from the array.

Same logic could be used with a Temporary Cursor, created at program startup and also associated with the oGlobal object for visibility throughout.

Just a scenario, trying to use Memory instead of actual disk storage and Table definitions, etc...might be a little bit faster also...

>Hi,
>
>>>
>or just create an Array of record #s and associated User IDs for 'checked out' records
><<
>
>But how are you going to populate the array <g>
>
>Regards,
>Viv
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform