Subject Re: [ib-support] generator question !!!
Author Moacir
Hi.. Sindu
To show the current value use SQL!!!...
select gen_id(your_generator_name,0) from rdb$database

In rdb$generator have fields...
RDB$GENERATOR_NAME = your_generator_name
RDB$GENERATOR_ID = generator_code (id)

But I still haven't found....
the values for each generator....


São Paulo - Brasil

----- Original Message -----
From: Sindu <sindu@...>
To: <>
Sent: Tuesday, March 20, 2001 3:17 AM
Subject: Re: [ib-support] generator question

> Hi Jason,
> Thanks for the tips about using gen_id( ,0).
> Anyway I'm just curious where the *IB Server* store the last value of the
> generator. I guess your tips means it doesn't expose it to any system
> tables then (like the way Oracle does in USER_SEQUENCES view).
> thanks & regards,
> Sindu