https://bugs.freedesktop.org/show_bug.cgi?id=72783
Priority: medium
Bug ID: 72783
Assignee: [email protected]
Summary: EDITING - Embedded Firebird doesn't support manual
creation of triggers
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.3.0.0.alpha0+ Master
Component: Database
Product: LibreOffice
One can not create a trigger manually in Tools > SQL if I follow the Firebird
FAQ :
http://www.firebirdfaq.org/faq29/
The generator statements appear to function correctly.
However :
1) The DDL have to be executed singly, i.e. it doesn't seem to possible to
execute several DDL statements in succession, separated by semi-colons ;
2) This means that statements like the following :
set term !! ;
CREATE TRIGGER T1_BI FOR T1
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
if (NEW.ID is NULL) then NEW.ID = GEN_ID(GEN_T1_ID, 1);
END!!
set term ; !!
fail miserably, either because "term" is not recognized, or if we remove the
set term statements, the DDL fails at line 5 (if (NEW.ID is NULL)... with the
semi-colon being interpreted as the end of the command and thereby ignoring
END.
So currently, unless I am doing something wrong (which is possible), there
seems to be no way to even manually create a trigger for an embedded firebird
db.
Will link to bug 69949 as they are related.
Alex
--
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
