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
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
Hello Herman
I had used UPDATE OR INSERT for several years in several hundred of tables.
No problem...with Firebird 2.5.x
But with Firebird 3.0.x I can not make it work.
If I write the identity column, doesn't work. If I don't write the identity
column, doesn't work.
Thank you very much for
Op 20/11/2020 om 01:04 schreef 'Walter R. Ojeda Valiente'
sistemas2000profesio...@gmail.com [firebird-support]:
I use firebird3 from libreoffice base, not directly, but in that way I
can make (and have done) such insert stattements.
CREATE TABLE MYTABLE (
COLUMN1 INTEGER GENERATED BY
CREATE TABLE MYTABLE (
COLUMN1 INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1) NOT NULL,
COLUMN2 VARCHAR(20));
ALTER TABLE MYTABLE ADD CONSTRAINT PK_MYTABLE PRIMARY KEY (COLUMN1);
Then, is I write it:
UPDATE OR INSERT INTO MYTABLE (COLUMN1, COLUMN2) VALUES (NULL, 'TEST')
The
I forget to say that my IDENTITY column is the Primary Key of MyTable,
therefore if I don't write it an error happens because...the table needs a
Primary Key.
On Thu, Nov 19, 2020 at 8:52 PM Walter R. Ojeda Valiente <
sistemas2000profesio...@gmail.com> wrote:
> Hello everybody
>
> A long, long