> Right. Generators are running outside of transaction control.

that's what I thought.

> But you can decrement a generator value by using a negativ number
> as increment. Perhaps this happens somewhere?

nope. never even crossed my mind--nor would I let code like that even
be played with in my main application. (Anything of that nature get's
done outside of the application, in testing apps).

> Although, that the numbers in the tables are correct, but the
> generator values are not, sounds weird, except you are fiddling
> around with decrementing generators, perhaps by accident.

it's really strange because the import utility that the person was
using imports data into 4 different tables. All 4 tables had problems
with their generators being reverted to what it looked like they had
been prior to the import.

This is the second time in a year I've seen this--happened to someone
elses database. Have thousands of users, probably 10-20 users who use
the import utility on a somewhat regular basis.