> Hello:
>
> I use Delphi 5 and IBX.
>
> I have a table TABLE1 with a field CODE1, a generator
> TABLE1_GEN_CODE1 and the next trigger:
>
> CREATE TRIGGER TABLE1_SET_CODE1
> FOR TABLE1
> BEFORE INSERT AS
> BEGIN
> NEW.CODE1 = GEN_ID(TABLE1_GEN_CODE1, 1);
> END;
>
> After I make a Post of a new record in TABLE1, I want to know
> the value of the field CODE1 that was assigned by the generator
> but the field that "identifies" the record is just the field
> CODE1, so I can´t make a SELECT... WHERE CODE1=XXX because I
> don´t know the value of XXX.
>
> I can make the next statement immediatly after the Post:
>
> SELECT GEN_ID(TABLE1_GEN_CODE1,0) FROM TABLE1
>
>
> and it works. But the question is: Is it possible that immediatly
> after my Post and before my SELECT another user makes a Post to
> TABLE1 incrementig the generator and then my SELECT obtains a
> value of the generator which is already incremented by one more
> than in my CODE1? If the answer is yes, then my next question is:
> How can I know the number assigned to fiele CODE1 immediatly
> after the INSERT statement?
>
> I tried to be clear but I don´t know if this message is clear enough.
>
> Thanks in advance
>
> Gustavo

even IBX provides for the ability to get the new gen value BEFORE you
insert. You therefore insert including this obtained values knowing that it
will never collide. You then use this same value after the insert in other
statements which require it.
Alan