Hello Daniel Yes, I agree with you, IDENTITY columns are useless for me, so I quit using them. Maybe for a log table or something so can serve, but for normal work they are useless.
I had returned to the old and well suitable practice of generator/trigger, so with a short stored procedure I can INSERT and UPDATE too. Fewer lines of code are a good practice according to my point of view. Greetings. Walter. On Tue, Nov 24, 2020 at 3:32 PM Daniel Miller [email protected] [firebird-support] <[email protected]> wrote: > > > I experimented with IDENTITY fields myself - based on my experience and > some older comments here I quit using them. I think they are presently > suitable for "quick" tables - something that will be append only like a log. > > If you're looking for more advanced features, like supporting UPDATE OR > INSERT (which I use myself), then you're much better off explicitly writing > the appropriate insert and update triggers. Possibly version 4 will > implement IDENTITY better but I don't use it all now. > > Daniel > > On 11/20/2020 5:59 AM, 'Walter R. Ojeda Valiente' > [email protected] [firebird-support] wrote: > > >
