> >If I want to implement "generator protection" - where should
> >I place it?
>
> Here's how I implemented that :
>
> CREATE TABLE TEST (TEST_ID INTEGER, CONSTRAINT TEST_PK PRIMARY
> KEY (TEST_ID));
>
> CREATE TRIGGER TRG_TEST_GEN_ID FOR QB_TEST1
> ACTIVE BEFORE INSERT POSITION 0
> AS
> declare variable GEN_VALUE Integer;
> begin
> if (new.TEST_ID is NULL) then
> new.TEST_ID = gen_id(GEN_TEST_ID,1);
> else
> begin
> GEN_VALUE = gen_id(GEN_TEST_ID,0);
> if (new.TEST_ID > GEN_VALUE) then
> GEN_VALUE = gen_id(GEN_TEST_ID,new.TEST_ID - GEN_VALUE);
> end
> end
>
> I've tested in some cases, it seems to work well event if
> previous insert failed (I just loose a generator value and make a
> "hole" that's not so important)
>
> Regards,
>
> Pierre

if you use this under heavy load you'll ruin your database
Alan