Subject Re: [IBO] Generator values not udpated
Author Aage Johansen
Ed Dressel wrote:
> ...
> the imported records seem to be getting the correct generated IDs, but
> then, after the import, the new generator values is not kept--it
> reverts back to its previous value.
>
> For example, it was 130. 50 new records are added, and the records
> have ID values values of 131...180. But then, after the import, the
> generator is 130.
>
> And I only see this very occasionally--very occasionally. But I have
> seen it more then once.
>
> I now check the generator values and IDs after the import, and if the
> generator is less then the max ID value, I reset it--it is a work
> around, but a bit ugly.
> ...

If this (resetting the generator) ever actually happens it indicates
a Firebird problem - no local genius will have the time to interfere
with the generator between the import and the resetting.
Still, I think the problem lies elsewhere ... <scratching head>
Do you log instances where your code catch the problem?

--
Aage J.