--- In firebird-support@yahoogroups.com, 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.