Hi,

> WOW, So I have to create a trigger for each table which adds another layer of maintenance issues?

Yes, an identity field is easier to set up, no question about that.

But once the generator and the trigger are there, they require no maintenance at all.

Compared to the time invested in designing the database, programming SP's, defining queries etc.,
the minutes "wasted" on setting up generators and one-line triggers are practically negligible.
For most Firebird developers, this is only a minor annoyance.
Still, I'll welcome the day when we have "real" auto-increment fields.


Paul Vinkenoog