|Subject||RE: [firebird-php] Re: using auto_number field|
>remember that when you use trigger to implements auto-inc field, you don´tRubbish.. you just ask for the generated value before you insert. Then you
>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
have it for the detail records as well.
SELECT GEN(MY_GEN, 1) FROM RDB$DATABASE