General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only