>remember that when you use trigger to implements auto-inc field, you don´t
>have control over the
>value. It is a problem qhen you use master-detail relationships. In my
>databases mny trigger had a
>test. If de value of a auto-inc is null or 0 (zero) then get a new
>enerator, othewise the aplication
>get the generator first and, with the value "in hands", send it to database
>in the insert command. then
>I had the key value for details.

>Diferents problems requires diferents solutions. One touch wizzard always
>resolves thr problems
>in the same way.

>Jean Paul Lopes
>Sócio-Gerente

Rubbish.. you just ask for the generated value before you insert. Then you
have it for the detail records as well.
ever seen
SELECT GEN(MY_GEN, 1) FROM RDB$DATABASE
?
Alan