Subject Re: [firebird-support] Maintaining proper generator values
Author Milan Babuskov
Doug Chamberlin wrote:
>>It can still lead to problems.
>
>
> How so?

Here's what you wrote earlier:

"Maintaining generator values which do not conflict with existing field
values is better done in the client. What I do while my client
application is starting up is to query the max existing value and if the
generator is currently set below that then I reset it to max+1."


I guess I misunderstood you. Somehow I missed that you're just doing
this at application startup.

One more thing, why max+1 ?
Setting it to max is enough.

--
Milan Babuskov
http://fbexport.sourceforge.net