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....

Ok?

Moacir
São Paulo - Brasil
moacirponti@...

----- Original Message -----
From: Sindu <sindu@...>
To: <ib-support@yahoogroups.com>
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