Hello River
Thanks for your suggestion but I need to use UPDATE OR INSERT.
I know that an INSERT without an IDENTITY column will work well. That's not
the problem.
But I never use INSERT, I always use UPDATE OR INSERT.
And with an IDENTITY column it is impossible to use UPDATE OR INSERT
therefo
On 25-11-2020 10:13, 'River~~' river14ap...@gmail.com [firebird-support]
wrote:
[..]
> I am also interested to know if you find my syntax works on v2.5, if
> you still have it installed to test it? Please don't go to the trouble
> of re-installing it just to test it.
>
> It is arguable that v3 is
hi Walter
Try
INSERT INTO mytable(column2) VALUES (12345)
In other words, do not try to insert the column you want to be
auto-generated. The database engine will notice that you are inserting
only a subset of the columns, and SHOULD use the default values for
the missing columns, which would be
