At 09:57 PM 7/11/2006, you wrote:

> > select gen_id(GEN_PREFS,(coalesce((select max(PREF_SN) from
> > WHATEVER),0))) from rdb$database
>
>errr... but this will not set the next value (or will it)? I.e after
>run once does 'gen_id' set the value against the GEN_PREFS generator?

Lick it and see for yourself. :-) (And...erm...this is something it
really pays you to *know* about generators...if you don't like
sleeping in the computer room...)

./heLen