Subject Re: [ib-support] auto increase
Author Doug Chamberlin
At 6/11/2001 03:47 PM (Monday), Ricardo Striquer Soares wrote:

>i am developing my fist interbase DB in wich i would like
>to use a double auto_increment oracles type

Interbase does not have an auto-increment field type. This sort of problem
is usually solved in Interbase using a generator together with a trigger
procedure. You define the generator and set it to a starting value. The
trigger then looks at the field in question and if it is NULL sets it to
the next value in the generated sequence.