sqlsvr wrote:

> Even if you could use DDL templates, maintaining 100+ triggers just for the purpose of auto incrementing keys is not efficient.

But it is much more PRACTICAL since it allows you to do cleaver things like
populate subdetail table entries using the SAME value you access from the
generator. You don't know the value of an 'auto-incremented' field until AFTER
it has been committed! Even better, you can use one generator for several key
fields, which in my own designs is another useful facility.

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php