Subject Re: generators
Author Alexander V.Nevsky
--- In firebird-support@yahoogroups.com, Pavol STÁREK PSŽ <pavol@s...>
wrote:
>There is a feature that are being developed that will make it easier and
> >avoid a two statments to be sent to the server, that is :
> >
> >insert into aTable (ColumnA, ColumnB, ColumnC) values (a, b, c)
returns
> >(or returning don't remember exactly) ColumnA
> >
> >see you !
> >
> >
> >
> Hi,
>
> this feature will be great... For now i use SP to get generated number
> and then insert it... Not very nice.

Of course this feature will be useful, but it'is necessary to bread
SPs only to get next generator value. Query

Select Gen_ID(MyGenerator,Increment) from rdb$database

can be used on client side.

Best regards,
Alexander.