Subject Re: [firebird-support] Multiple generators
Author Daniel Rail

At June 12, 2006, 12:13 PM, killerion wrote:

> In my DB, I need to keep track of different the offices of a company,
> and they want to be able to create or eliminate the offices, but
> depending on type, location, etc... they have different types of
> identifiers, now I want to know if I can use multiple generators for
> one table or do I need to manage them in different tables... if it is
> possible to do this how?

Generators are not really linked to a table. They end up being linked
by the way of a trigger. So, yes you can have multiple generators per

Here are some ideas in how I would approach this problem. It would be
to have a primary key field based on a generator generated value, this
field is basically for easier updating, even if the user would most
likely never see this value. And, have a generator for each office
with a trigger that would be able to distinguish for which office the
record is for and use the proper generator. Or, you could use a table
containing the list of generators with the corresponding table and
office, and use that table as your reference for which generator to

Best regards,
Daniel Rail
Senior Software Developer
ACCRA Consultants Inc. (
ACCRA Med Software Inc. (