Exactly, and, as I asked before, how's the generator getting set back.
It should never be, by any application, user, whatever, as far as I'm
concerned.
We *never* set them in any application, etc., and if a user (which I can't
see ever happening, as the vast majority of our users don't have access to
the database, or the raw data) ever did (or one of our own site techs),
there would be hell to pay ;)



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



-----Original Message-----
From: soso_pub [mailto:soso_pub@...]
Sent: Tuesday, November 11, 2003 2:33 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Maintaining proper generator values


I followed the discussion briefly and I would like to add a point. I
think that using _only_ the GEN_ID(...) function will not generate
duplicate values, regardless of the number of concurent conections and
the step of the generator per connection. This is what I concluded
from the documentation of IB6 and this is how it should be.
On the other hand, if you reset the value of the generator with SET
GENERATOR to a smaller value than the current, this could cause trouble.





Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=12c4rkg0e/M=258297.4155332.5363524.4049140/D=egroup
web/S=1705115386:HM/EXP=1068672768/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=348112804>

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]