Subject | Re: [IBO] Generator values not udpated |
---|---|
Author | Aage Johansen |
Post date | 2008-11-07T19:30:25Z |
Ed Dressel wrote:
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.
> ...If this (resetting the generator) ever actually happens it indicates
> 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.
> ...
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.