[Libreoffice-bugs] [Bug 105220] Firebird: Insert with direct SQL - RETURNING without values

https://bugs.documentfoundation.org/show_bug.cgi?id=105220 Robert Großkopf changed: What|Removed |Added Blocks||154426 Referenced Bugs:

[Libreoffice-bugs] [Bug 105220] Firebird: Insert with direct SQL - RETURNING without values

https://bugs.documentfoundation.org/show_bug.cgi?id=105220 --- Comment #16 from Julien Nabet --- (In reply to Robert Großkopf from comment #15) > (In reply to Robert Großkopf from comment #14) > > > > Seems returning content when inserting values is a special behavior of > > Firebird, which

[Libreoffice-bugs] [Bug 105220] Firebird: Insert with direct SQL - RETURNING without values

https://bugs.documentfoundation.org/show_bug.cgi?id=105220 --- Comment #15 from Robert Großkopf --- (In reply to Robert Großkopf from comment #14) > > Seems returning content when inserting values is a special behavior of > Firebird, which can't work with this construction of executeQuery and >

[Libreoffice-bugs] [Bug 105220] Firebird: Insert with direct SQL - RETURNING without values

https://bugs.documentfoundation.org/show_bug.cgi?id=105220 --- Comment #14 from Robert Großkopf --- (In reply to Julien Nabet from comment #13) > > We only expect the number of rows inserted here. > I thought we could add a test here to check if it contains RETURNING but no > idea then how to

[Libreoffice-bugs] [Bug 105220] Firebird: Insert with direct SQL - RETURNING without values

https://bugs.documentfoundation.org/show_bug.cgi?id=105220 --- Comment #13 from Julien Nabet --- (In reply to Robert Großkopf from comment #12) > Have tested this again. Nothing changed. > ... Ok then. Just for the record, here's the entry point. In dbaccess/source/ui/dlg/directsql.cxx, we got:

[Libreoffice-bugs] [Bug 105220] Firebird: Insert with direct SQL - RETURNING without values

https://bugs.documentfoundation.org/show_bug.cgi?id=105220 --- Comment #12 from Robert Großkopf --- Have tested this again. Nothing changed. @Julien: The way you described is the workaround I have also written in Base Handbuch: SELECT RDB$FIELD_NAME, RDB$RELATION_NAME, RDB$GENERATOR_NAME FROM

[Libreoffice-bugs] [Bug 105220] Firebird: Insert with direct SQL - RETURNING without values

https://bugs.documentfoundation.org/show_bug.cgi?id=105220 Julien Nabet changed: What|Removed |Added CC||serval2...@yahoo.fr --- Comment

[Libreoffice-bugs] [Bug 105220] Firebird: Insert with direct SQL - RETURNING without values

https://bugs.documentfoundation.org/show_bug.cgi?id=105220 --- Comment #10 from Buovjaga --- Hmm, but according to https://wiki.documentfoundation.org/Documentation/FirebirdMigration#Data_engine_standard_functions Firebird does not have a function matching IDENTITY() -- You are receiving this

[Libreoffice-bugs] [Bug 105220] Firebird: Insert with direct SQL - RETURNING without values

https://bugs.documentfoundation.org/show_bug.cgi?id=105220 --- Comment #9 from Buovjaga --- Some small pointers: The direct SQL dialog is here: dbaccess/source/ui/dlg/directsql.cxx About HSQLDB's IDENTITY(), search in this guide: http://hsqldb.org/doc/1.8/guide/guide.html -- You are

[Libreoffice-bugs] [Bug 105220] Firebird: Insert with direct SQL - RETURNING without values

https://bugs.documentfoundation.org/show_bug.cgi?id=105220 Robert Großkopf changed: What|Removed |Added Attachment #138875|0 |1 is obsolete|

[Libreoffice-bugs] [Bug 105220] Firebird: Insert with direct SQL - RETURNING without values

https://bugs.documentfoundation.org/show_bug.cgi?id=105220 --- Comment #7 from Robert Großkopf --- Bug still exists. Tested with Version: 6.2.0.1 Build ID: 0412ee99e862f384c1106d0841a950c4cfaa9df1 CPU threads: 6; OS: Linux 4.12; UI render: default; VCL: gtk3; Locale: de-DE (de_DE.UTF-8);

[Libreoffice-bugs] [Bug 105220] Firebird: Insert with direct SQL - RETURNING without values

https://bugs.documentfoundation.org/show_bug.cgi?id=105220 --- Comment #6 from QA Administrators --- ** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to

[Libreoffice-bugs] [Bug 105220] Firebird: Insert with direct SQL - RETURNING without values

https://bugs.documentfoundation.org/show_bug.cgi?id=105220 --- Comment #5 from rob...@familiegrosskopf.de --- (In reply to Lionel Elie Mamane from comment #3) > Could you please share the macro? Did you use executeQuery or execute? (I > assume not executeUpdate...) Did use executeQuery, because

[Libreoffice-bugs] [Bug 105220] Firebird: Insert with direct SQL - RETURNING without values

https://bugs.documentfoundation.org/show_bug.cgi?id=105220 rob...@familiegrosskopf.de changed: What|Removed |Added Attachment #130288|0 |1 is

[Libreoffice-bugs] [Bug 105220] Firebird: Insert with direct SQL - RETURNING without values

https://bugs.documentfoundation.org/show_bug.cgi?id=105220 --- Comment #3 from Lionel Elie Mamane --- (In reply to robert from comment #2) > Have tested this with a macro. Could you please share the macro? Did you use executeQuery or execute? (I assume not executeUpdate...)

[Libreoffice-bugs] [Bug 105220] Firebird: Insert with direct SQL - RETURNING without values

https://bugs.documentfoundation.org/show_bug.cgi?id=105220 --- Comment #2 from rob...@familiegrosskopf.de --- Have tested this with a macro. Firebird returns nothing to Base except a "." So there couldn't be tested the last input and the last inserted AutoValue. All tested with Version:

[Libreoffice-bugs] [Bug 105220] Firebird: Insert with direct SQL - RETURNING without values

https://bugs.documentfoundation.org/show_bug.cgi?id=105220 m.a.riosv changed: What|Removed |Added OS|Linux (All) |All

[Libreoffice-bugs] [Bug 105220] Firebird: Insert with direct SQL - RETURNING without values

https://bugs.documentfoundation.org/show_bug.cgi?id=105220 m.a.riosv changed: What|Removed |Added Status|UNCONFIRMED |NEW