Is this particular user computer literate or has access to someone that are? I wouldn't suspect a an illiterate person to mess around with generators, but I can imagine normal programmers like most of us to write code that got the generators value, executed something and then reset the generator. If someone wrote code like this and intended it for testing purposes (e.g. when you import and then delete and want everything to be as before you started testing) and someone uses it in a production environment without wanting to delete anything, then I would expect things like what you are observing to happen.

I'm not ruling out the possibility that the database has an error, it is just that user mistakes/misuse are more common.

Set

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf Of Ed Dressel
Sent: 7. november 2008 05:09
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Generator values not udpated

> 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.