https://bugs.freedesktop.org/show_bug.cgi?id=79487

--- Comment #6 from [email protected] ---
@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
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to