Yes that could be one method. However at the time of entry I would also like the user to see the bill serial number. I think this would then involve some extra work as at the time of saving one would actually have to go through the file to ensure that there are no gaps.
>One way I can think of is to have the table containing the bill serial number ordered by that field. When saving the record, go to the last record, attempt to lock it, increment the number and save the new record, then release the record lock.
>
>
>
>>In one of my applications in a Multiuser environment, the bills entered require to have a serial number which is sequential. I had read an article relating to this on the MSDN site and unfortunately can't locate it a present. Would somebody kindly point me to that article or any similiar articles on how to implement this. Any Suggestions in this regard would be helpfull.
>>
>>Thanks
>>
>>Anurag
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