Subject Re: [firebird-support] Generatorvalues and trigger ?
Author Martijn Tonies
Hello Hans,

>I think I checked all the RDB$... relations, but cannot find where the
> current values for the Generators are kept.
>
> Also, can there be a (on update) trigger setup available for Generators ,
> triggered whenever they change value?

Generator values aren't kept in any of the RDB$ tables, they're
kept at a special area on disk in the database, the so called
"generator page".

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com