On 10/22/07, Adam Glauser <adamglauser@xxxxxxxxxxxx> wrote:
Paul Nelson wrote:
I think I will start with the machine
number as the first digit and start with 000001 for the first employee and
work my way up from there.


If you can make it work, good luck. I've not seen a good way of
implementing a unique, sequential numbering scheme across multiple
machines and databases.
I worked for a software company who had developed an internal routine
that used a unique numbering scheme they called a "surrogate" for many
of the tables in the database, giving them unique, sequential keys. It
was ugly. Customers who had implemented this had problems when trying
to copy or convert/copy databases from test to production, and from
machine to machine or if the library names were changed. We re-wrote
it to use a unique key combination of System Serial Number + Library
Name + DateTimestamp (Julian Date + 9 digit time stamp HHMMSSNNN).
Admittedly, the solution wasn't much prettier, but it was unique
across multiple machines and databases, so if the data ever had to be
merged it wasn't a problem.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.