Re: Autoinc "skipped a beat"...?

#1

Kenneth,

You didn't delete any records? Autoinc fields have a "memory". They don't
just go by what the last number still in the table is, they go by what the
last number added to the table was, whether it's still there or not.

Liz

Kenneth <usenet (AT) soleSPAMLESSassociates (DOT) com> wrote:

Quote:

Howdy,

Yesterday, for a modest group emailing, I needed to build a
table of 60 records and did that in P9.

My first field (keyed) was an autoinc. (I know the reasons
to avoid using an autoinc field, but was not joining to any
other table, and would not use this table again so went with
the convenience.)

This morning, I had to add two records to the table, and was
surprised to see that the autoinc "skipped" a few beats,
that is, instead of entering "61", the next integer in
sequence, it jumped to 63, and then 64.

It is of no consequence in my situation, but I was wondering
if someone could tell me why that might happen.

Thanks,
--
Kenneth

If you email... Please remove the "SPAMLESS."

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Autoinc "skipped a beat"...?

comp.databases.paradox comp.databases.paradox

Re: Autoinc "skipped a beat"...? - 02-09-2007 , 01:16 PM