[Libreoffice-bugs] [Bug 79487] Other: Base should interpret set term command
https://bugs.freedesktop.org/show_bug.cgi?id=79487 --- Comment #9 from reinierolislag...@gmail.com --- (In reply to reinierolislagers from comment #6) *If* Libreoffice is not able to parse a script like this: CREATE PROCEDURE givetheanswer RETURNS (ANSWER INTEGER) AS BEGIN -- bigger procedures often need comments. FOR select 42 from rdb$database into :ANSWER DO SUSPEND; END^ Oops, that should have been the last end without ^ CREATE PROCEDURE givetheanswer RETURNS (ANSWER INTEGER) AS BEGIN -- bigger procedures often need comments. FOR select 42 from rdb$database into :ANSWER DO SUSPEND; END; Just created a new query, set SQL mode to true and ran it. Although the query complained about not returning a result set, that was the only error. I tried calling the created stored procedure with this query: select answer from givetheanswer standard mode gave The statement contains a cyclic reference to one or more subqueries Native SQL mode: Table not found in statement [SELECT answer FROM gettheanswer] This query does work in Firebird tools (e.g. Flamerobin). Adding database with queries (test3.odb). -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 79487] Other: Base should interpret set term command
https://bugs.freedesktop.org/show_bug.cgi?id=79487 --- Comment #10 from reinierolislag...@gmail.com --- Created attachment 107408 -- https://bugs.freedesktop.org/attachment.cgi?id=107408action=edit Test database with create stored procedure query and query getting stored proc result -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 79487] Other: Base should interpret set term command
https://bugs.freedesktop.org/show_bug.cgi?id=79487 Lionel Elie Mamane lio...@mamane.lu changed: What|Removed |Added Status|UNCONFIRMED |ASSIGNED Assignee|libreoffice-b...@lists.free |lio...@mamane.lu |desktop.org | Ever confirmed|0 |1 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 79487] Other: Base should interpret set term command
https://bugs.freedesktop.org/show_bug.cgi?id=79487 --- Comment #7 from Julien Nabet serval2...@yahoo.fr --- (In reply to reinierolislagers from comment #6) Sorry, cannot test myself, don't have working Firebird connectivity with my LibreOffice. Firebird support is experimental. To enable it, you must do: - Tools/Options/Advanced - check Enable experimental features - restart LibreOffice -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 79487] Other: Base should interpret set term command
https://bugs.freedesktop.org/show_bug.cgi?id=79487 --- Comment #8 from reinierolislag...@gmail.com --- I know. I'm facing bug 84618. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 79487] Other: Base should interpret set term command
https://bugs.freedesktop.org/show_bug.cgi?id=79487 --- Comment #6 from reinierolislag...@gmail.com --- @Julien Nabet: SET TERM is not a Firebird SQL command but a client (isql, Flamerobin,...) command so it is expected that you get an SQL error from the server. See http://www.firebirdfaq.org/faq78/ Note: most Firebird DDL scripts with trigger/stored procedure/generator creation will use SET TERM so having the ability to parse this would be useful in Libreoffice. *If* Libreoffice is not able to parse a script like this: CREATE PROCEDURE givetheanswer RETURNS (ANSWER INTEGER) AS BEGIN -- bigger procedures often need comments. FOR select 42 from rdb$database into :ANSWER DO SUSPEND; END^ ... then parsing SET TERM would be *necessary*: SET TERM ^ ; CREATE PROCEDURE givetheanswer RETURNS (ANSWER INTEGER) AS BEGIN -- bigger procedures often need comments. FOR select 42 from rdb$database into :ANSWER DO SUSPEND; END^ SET TERM ; ^ Sorry, cannot test myself, don't have working Firebird connectivity with my LibreOffice. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 79487] Other: Base should interpret set term command
https://bugs.freedesktop.org/show_bug.cgi?id=79487 --- Comment #3 from Julien Nabet serval2...@yahoo.fr --- (In reply to comment #2) ... To pass a command to a linked database go into the query design view. Enter command and click Run SQL Command Directly. See Wiki entries: https://help.libreoffice.org/Common/Run_SQL_command_directly https://help.libreoffice.org/Common/Executing_SQL_Commands https://help.libreoffice.org/Common/Execute_SQL_statement Please verify this gives expected results. I don't see the Run Sql command directly, can you attach a screenshot or give precise steps. The wiki entry didn't help me :-( -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 79487] Other: Base should interpret set term command
https://bugs.freedesktop.org/show_bug.cgi?id=79487 Julien Nabet serval2...@yahoo.fr changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 79487] Other: Base should interpret set term command
https://bugs.freedesktop.org/show_bug.cgi?id=79487 --- Comment #4 from topcyde xenophonscha...@hotmail.com --- Created attachment 101779 -- https://bugs.freedesktop.org/attachment.cgi?id=101779action=edit Screen capture of how to execute running an SQL command directly -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 79487] Other: Base should interpret set term command
https://bugs.freedesktop.org/show_bug.cgi?id=79487 --- Comment #5 from Julien Nabet serval2...@yahoo.fr --- Thank you for your help! Now when running the sql without run direct sql, I got: SQL Status: HY000 Error code: 1000 syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE and with it, I've got: Error code: 1 firebird_sdbc error: *Dynamic SQL Error *SQL error code = -104 *Token unknown - line 1, column 5 *term caused by 'isc_dsql_prepare' -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 79487] Other: Base should interpret set term command
https://bugs.freedesktop.org/show_bug.cgi?id=79487 topcyde xenophonscha...@hotmail.com changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||xenophonscha...@hotmail.com Ever confirmed|0 |1 --- Comment #2 from topcyde xenophonscha...@hotmail.com --- If using an embedded HypersonicSQL databse SET TERM is not an HSQL command. To pass a command to a linked database go into the query design view. Enter command and click Run SQL Command Directly. See Wiki entries: https://help.libreoffice.org/Common/Run_SQL_command_directly https://help.libreoffice.org/Common/Executing_SQL_Commands https://help.libreoffice.org/Common/Execute_SQL_statement Please verify this gives expected results. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 79487] Other: Base should interpret set term command
https://bugs.freedesktop.org/show_bug.cgi?id=79487 Julien Nabet serval2...@yahoo.fr changed: What|Removed |Added CC||lio...@mamane.lu --- Comment #1 from Julien Nabet serval2...@yahoo.fr --- I tried to add this on connectivity/source/parse/sqlflex.l TERM{SQL_NEW_KEYWORD(SQL_TOKEN_TERM); } but then I'm stuck with Bison part. I don't know at all Lex/Flex and Bison. Lionel: any idea? -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 79487] Other: Base should interpret set term command
https://bugs.freedesktop.org/show_bug.cgi?id=79487 Julien Nabet serval2...@yahoo.fr changed: What|Removed |Added See Also||https://bugs.freedesktop.or ||g/show_bug.cgi?id=69949 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs