Hi all,

I have a DSQL component that inserts records in a table. I have a Before
Insert trigger with : NEW.RegistNo = gen_id (RegistNo_Gen, 1). After the
DSQL component, I would like to know the value of NEW.RegistNo. Since many
people are inserting data in that table, it's risky to take the last value
of the generator, because another user may have entered a record already.
I'm using the DSQl component for the fast speed.

Thank you,

Nico Callewaert,

ncw@...
nico.callewaert@...