[StBernard] Gutting List

Westley Annis westley at da-parish.com
Sun May 21 20:40:45 EDT 2006



Westley, you're probably right except I just checked those two lists and
some entries had a unique ID and some didn't. It would be interesting if
you could sort the different fields and sort on that one ascending to see if
they are counters or what.

Jim




-----------------------------------------------------
Jer,

I'm sure that it is nothing more than exactly what it looks like, a
unique
identifier.

Standard database practices requires that every record has one piece
of
information that is unique among all the other records. Depending on
the
information that is being recorded, it is very common to just use a
counter
that automatically increments every time a new record is added.

Although this would give you a rough idea of how many records are in
the
database and what order they were entered, it cannot be assumed that
either
is correct. Some multiuser databases increment the number once the
form is
displayed to enter a new record. If no record is saved, that number
is then
discarded, never to be used.

All in all, outside of the database, the UNIQUE_ID is a meaningless
number
and should be ignored.

Westley






More information about the StBernard mailing list