Sequential Part Number Generator...with a twist

[Richard Witkopp]

If you're using a relational database, some of them have
a dataype that's sequentually incremented. The database takes
care of making sure there are no duplicates. Maybe you can
use it for a field segment.

> The users would like a sequentially generated field.  The 
> field is split
> into two sections  XXXXX-XXX (Ex.   000012, 000013-001, 
> 000014, 000014-001,
> etc.)  and is handled with three variables.  The first 5 
> characters is the
> field that is generated sequentially.  In entry mode the user 
> would hit the
> enter key and the next number would be generated automatically and the
> cursor would move to the last three digits and the dash in 
> between would be
> displayed or the user can enter up to 5 digits of a previous record to
> append to the end of it with three additional characters.  
> The user has the
> option to enter up to three characters or hit the enter key.  
> If the enter
> key is pressed without entering data the dash disappears and 
> the second
> field is left blank.  My problem is if two people are 
> accesssing this screen
> at one time two or more users can grab the same sequentially generated
> number.  What I need to do is do commit the record after the 
> second field of
> three characters is passed.  If anyone knows of something 
> remotely close to
> what I am attempting to do I would greatly appreciate the 
> feedback.  Thanks,
> Chris

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.