https://bugs.freedesktop.org/show_bug.cgi?id=79487
--- Comment #9 from [email protected] --- (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 [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
