Subject Re: Auto Incrementing field
Author benmarron
--- In, Bahadir ARMAGAN
<barmagan@t...> wrote:
> Thank you for your explanation. I did it.
> Now how can I get this auto generated vaule when I insert records? I
have an
> example for mssql server which uses @@IDENTITY for returning this value.
> Does it work for firebird?
> Should I start a new message thread for this?

I think Gen_id function can do this job.

Syntax is : gen_id ( generator, step)

If you set argument "step" to 1, the function increment the generator
by 1 and returns the value of the generator.

If you set argument "step" to 0, the function returns the value of the
generator without increment or decrement.