>If you are concerned about making the ID numbers tight with no gaps, then
>structure your new Id table like this:
>
>TYPE NUMBER
>
>NEW 000564
>SALVAGE 000563
>
>When you go to add a new ID, FIRST search for a SALVAGE type...If found() Lock
>it, use it, deleted it. If its NOT found(), search for a NEW type...lock it,
>increment it, unlock it.
>
>And no matter what...If the save falls through, Insert the unused ID number
>into the table as a SALVAGE type.
>
>In otherwards...The salvage type will always hold FAILED ID numbers...and you
>will always use them first.
Mike,
What would happen if you have say three users all start adding a new record and
all three end up cancelling the adds? I don't see how your structure would
support multiple IDs to salvage. Am I missing something?
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