https://bugs.documentfoundation.org/show_bug.cgi?id=148266
Bug ID: 148266 Summary: Firebird, entering several SQL commands directly together Product: LibreOffice Version: 7.2.6.2 release Hardware: x86 (IA32) OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Base Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: bugreport...@protonmail.com Description: In HSQLDB I could enter several commands directly in Tools > SQL: ALTER TABLE "Adresse" ADD "Vorname" VARCHAR(25) BEFORE "Name" ALTER TABLE "Adresse" ADD "email" VARCHAR(50) BEFORE "Name" All were executed together at once. In Firebird only one command can be entered and executed. Several commands: ALTER TABLE table_name ALTER field_name POSITION 1 ALTER TABLE table_name ALTER field_name2 POSITION 2 ALTER TABLE table_name ALTER field_name3 POSITION 3 or ALTER TABLE table_name ALTER field_name POSITION 1; ALTER TABLE table_name ALTER field_name2 POSITION 2; ALTER TABLE table_name ALTER field_name3 POSITION 3 or ALTER TABLE table_name ALTER field_name POSITION 1, ALTER TABLE table_name ALTER field_name2 POSITION 2, ALTER TABLE table_name ALTER field_name3 POSITION 3 result in this error message: *Token unknown - line 2, column 1 *ALTER caused by 'isc_dsql_prepare' It is time consuming to enter each command separately. Steps to Reproduce: 1. enter in Tools > SQL: ALTER TABLE table_name ALTER field_name POSITION 1 ALTER TABLE table_name ALTER field_name2 POSITION 2 ALTER TABLE table_name ALTER field_name3 POSITION 3 or ALTER TABLE table_name ALTER field_name POSITION 1; ALTER TABLE table_name ALTER field_name2 POSITION 2; ALTER TABLE table_name ALTER field_name3 POSITION 3 or ALTER TABLE table_name ALTER field_name POSITION 1, ALTER TABLE table_name ALTER field_name2 POSITION 2, ALTER TABLE table_name ALTER field_name3 POSITION 3 Actual Results: error message: *Token unknown - line 2, column 1 *ALTER caused by 'isc_dsql_prepare' Expected Results: 1: Reproducible: Always User Profile Reset: Yes Additional Info: no other info -- You are receiving this mail because: You are the assignee for the bug.