I must apologize for incomplete reply.
Thanks to Richard and Martin for explanations.

--- In firebird-support@yahoogroups.com, "Richard Pendered"
<rpendered@t...> wrote:

> What you should do is to get the next generator value first (select

gen_d(

> generator,1 ) from rdb$database), then use that in your insert

statement. If

> you have made use of the extra checks by Alex Taylor, it shoudl work as
> expected.
> Be aware that calls to gen_id are not under transaction control, and are
> therefore safe to use like this as you will not get duplicates

(assumung you

> use a step of more than 0).
>
> -----Original Message-----
> From: benmarron [mailto:colletb@m...]
> Sent: 10 December 2003 08:42
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Re: Auto Incrementing field
>
>
> --- 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.
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/