Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Soft locks and table buffering
Message
De
18/09/2002 18:15:36
Irv Adams
MSC Managed Care, Inc.
Floride, États-Unis
 
 
À
18/09/2002 04:54:59
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00700960
Message ID:
00702051
Vues:
23
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
Fil
Voir

Click here to load this message in the networking platform