Subject Re: [IBO] GENERATORS
Author Nando Dessena
radevojvodic:

> I'm thinking about GeneratorLink usage and i find it unefficient. For
> example if you set this property for a primary key and you put your
> query in insert state generator is called imedietly.

I have put up this issue on several occasions. Being able to posticipate
the GEN_ID call untile BeforePost (as opposed to AfterInsert) is
something that I find useful sometimes. I remember I have also tried to
make the idea desirable saying that IBX supports that, but no luck. ;-)

When I need that behaviour, I have been told, I should just not use
GeneratorLinks and call Gen_ID on BeforePost myself, which is what I
did. Apparently, all the other IBO users are satisfied with the
AfterInsert behaviour.

> So you
> incremented generator value. Then You cancel insert and your
> generator value is still incremented.

I think this can't be avoided unless you want some problems in handling
your concurrency (and then you wouldn't be using generators).
Ciao
--
____
_/\/ando