Re: [firebird-support] Re: UPDATE OR INSERT in Firebird 3

2020-11-20 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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 you

Re: [firebird-support] Re: UPDATE OR INSERT in Firebird 3

2020-11-20 Thread Herman Viaene herman.via...@edpnet.be [firebird-support]
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 DEFAULT