×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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.
midrange.com
