The real question is *how* the generator(s) could have gotten set wrongly ??
We never see it.
No client application ever sets a generator.


Best regards,
Fred Wilson
SE, Böwe Bell & Howell
fred.wilson@... <mailto:fred.wilson@...>


-----Original Message-----
From: Milan Babuskov [mailto:albis@...]
Sent: Tuesday, November 11, 2003 12:52 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Maintaining proper generator values


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 <http://fbexport.sourceforge.net>




Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=12cijp799/M=258297.4155332.5363524.4049140/D=egroup
web/S=1705115386:HM/EXP=1068666748/A=1683962/R=0/*http://www.techsmith.com/r
dr/ban/syah/default.asp> click here

<http://us.adserver.yahoo.com/l?M=258297.4155332.5363524.4049140/D=egroupmai
l/S=:HM/A=1683962/rand=639015084>

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]