Information générale
Catégorie:
Programmation Orientée Object
>John,
>
>In the Default Value of the ID field I put the code GenerateID("Mytable", "MyIndex") which calls a function GenerateID(). This function is kept in the same folder as the tables, although it COULD be added to the Stored Procedures.
>
>The function loads an ID table, looks for a record for 'MyTable' and defaults to the index 'MyIndex'. The record is locked, a value is incremented and the new value is used as the ID. With record locking I can be sure that only one user gets the next ID.
>
>And yes, this is always a Primary index.
>
>HTH
>Barbara
Barbara,
Does putting the call to GenerateID() in the default value automaticaly add the new index value when you append a new record?
I use a seperate table and code to generate a unique index value for any table in the application. It sounds similar to the one you use except for the record locking (I have none at the moment).
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