> select gen_id(GEN_AGENDA_NRO, 287390 - gen_id(GEN_AGENDA_NRO , 0)) from > rdb$database
An ugly hack, I agree, but works. >This does make you wonder if maybe RESTART WITH shouldn't fall under >USAGE instead of the ALTER privilege (or alternatively if using gen_id >with anything other than 0 or 1 shouldn't fall under the ALTER privilege). I agree also: a bit strange. Thanks. Aldo Caruso
