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 message
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 ti
Hello everybody
A long, long time without writing neither reading this group, mostly
because all that I need about Firebird I knew.
But now, I have a doubt.
With Firebird 2.5.x I can have an auto-incremental column and use it in an
UPDATE OR INSERT, but such thing is not possible with Firebird 3