On Wed, 07 Sep 2011 19:23:11 -0000, "Ronan Keating" <tanjuozgur@...>
wrote:

> --- In firebird-support@yahoogroups.com, Ann Harrison <aharrison@...>
> wrote:
>>
>> 2011/9/7 Svein Erling Tysvær <svein.erling.tysvaer@...>
>>
>
>> > Another thing is that I would recommend you not to use 'set
>> Although Svein is almost always right about everything, in this case

he's

>> overgeneralized a good warning. Several things in the database

metadata

>> have limits on the number of times they can be modified, including the
>> number of generators you can define, but resetting a generator leaves

no

>> traces and can be done as often as you wish.
>>
>> Good luck,
>>
>> Ann
> Thank for your remarks,
> but I've to overcome that hurdle, IMHO bottle-neck is that generator

there

> should be more elegant way for numbering the rows such as in MSSQL
> row_number().

That is planned for Firebird 3.0:
http://tracker.firebirdsql.org/browse/CORE-2830