Subject Re: [firebird-support] problem - change autoincrement fields to identity fields
Author Lester Caine
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 -
L.S.Caine Electronic Services -
EnquirySolve -
Model Engineers Digital Workshop -
Rainbow Digital Media -