On 18/11/16 11:03, Nico Speleers - Carfac BVBA nico.speleers@...
[firebird-support] wrote:

> But I want to use identity fields because such fields don't uses a generator and a trigger.

Putting this a different way ... the correct way of ensuring where
multiple users are adding records which require a unique ID, SQL
introduced SEQUENCE which is the same thing as the Interbase generator
which pre-dates it. So a reliable 'identity' or 'auto-increment' field
is simply a wrapper for sequence or generator. I prefer access to the
trigger to allow more than a simple 'get next number' but if you prefer
to hid it fine. That is all you are doing by changing the code used ...

--
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
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk