[Libreoffice-bugs] [Bug 148266] Firebird: entering several SQL commands directly with delimiter impossible
https://bugs.documentfoundation.org/show_bug.cgi?id=148266 Julien Nabet changed: What|Removed |Added Blocks|116968 |51780 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=51780 [Bug 51780] [META] Default to Firebird not HSQLDB in Base (for _new_ files) https://bugs.documentfoundation.org/show_bug.cgi?id=116968 [Bug 116968] [META] Migrating existing embedded HSQLDB databases to Firebird -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148266] Firebird: entering several SQL commands directly with delimiter impossible
https://bugs.documentfoundation.org/show_bug.cgi?id=148266 Julien Nabet changed: What|Removed |Added Blocks||116968 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=116968 [Bug 116968] [META] Migrating existing embedded HSQLDB databases to Firebird -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148266] Firebird: entering several SQL commands directly with delimiter impossible
https://bugs.documentfoundation.org/show_bug.cgi?id=148266 --- Comment #5 from bugreport...@protonmail.com --- in Tools > SQL: execute block as begin ALTER TABLE "0base" ALTER "eL1" POSITION 1; ALTER TABLE "0base" ALTER "eL2" POSITION 2; ALTER TABLE "0base" ALTER "eL3" POSITION 3; end results in: 1: firebird_sdbc error: *Dynamic SQL Error *SQL error code = -104 *Token unknown - line 3, column 3 *ALTER caused by 'isc_dsql_prepare' each SQL command alone works. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148266] Firebird: entering several SQL commands directly with delimiter impossible
https://bugs.documentfoundation.org/show_bug.cgi?id=148266
--- Comment #4 from Robert Großkopf ---
Seems Firebird needs a special EXECUTE BLOCK for this:
execute block as
begin
INSERT INTO "table" ("ID") VALUES(4);
INSERT INTO "table" ("ID") VALUES(5);
INSERT INTO "table" ("ID") VALUES(6);
end
will work here.
--
You are receiving this mail because:
You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148266] Firebird: entering several SQL commands directly with delimiter impossible
https://bugs.documentfoundation.org/show_bug.cgi?id=148266 --- Comment #3 from Robert Großkopf --- I have also searched for it. Seems it is a little bit confused: https://www.firebirdsql.org/pdfmanual/html/isql-terminator.html The terminator seems to be a ';' by default. But it won't run from Base … -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148266] Firebird: entering several SQL commands directly with delimiter impossible
https://bugs.documentfoundation.org/show_bug.cgi?id=148266 Julien Nabet changed: What|Removed |Added CC||serval2...@yahoo.fr --- Comment #2 from Julien Nabet --- Searching "firebird multiple statements", just wonder if it's possible in Firebird. I found an old link here: https://stackoverflow.com/questions/1698114/firebird-multiple-statements about "execute block" Also: https://firebirdsql.org/manual/migration-mssql-syntax.html -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148266] Firebird: entering several SQL commands directly with delimiter impossible
https://bugs.documentfoundation.org/show_bug.cgi?id=148266 Robert Großkopf changed: What|Removed |Added OS|Windows (All) |All -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148266] Firebird: entering several SQL commands directly with delimiter impossible
https://bugs.documentfoundation.org/show_bug.cgi?id=148266 Robert Großkopf changed: What|Removed |Added Status|UNCONFIRMED |NEW Summary|Firebird, entering several |Firebird: entering several |SQL commands directly |SQL commands directly with |together|delimiter impossible CC||rob...@familiegrosskopf.de Ever confirmed|0 |1 --- Comment #1 from Robert Großkopf --- Have tested this with the described command ALTER TABLE table_name ALTER field_name POSITION …; and also with INSERT INTO table_name (fieldname) VALUES(…); Could only execute one command. Delimiter ';' doesn't work in Firebird. Seems it is the same behavior in Firebid server connecting by JDBC. So could be a special Firebird bug? All tested with LO 7.3.2.2 on OpenSUSE 15.3 64bit rpm Linux. -- You are receiving this mail because: You are the assignee for the bug.
