Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement