Subject | Re: [firebird-support] Maintaining proper generator values |
---|---|
Author | Milan Babuskov |
Post date | 2003-11-11T19:52:24Z |
Doug Chamberlin wrote:
"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
>>It can still lead to problems.Here's what you wrote earlier:
>
>
> How so?
"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