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. ;-)
http://tracker.firebirdsql.org/browse/CORE-1385


--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

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