Subject Re: [firebird-support] Re: Identity
Author Thomas Steinmaurer
Hello Paul,

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

In V3. ;-)

With regards,

Thomas Steinmaurer
Upscene Productions

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!