https://bugs.documentfoundation.org/show_bug.cgi?id=122048
--- Comment #2 from Drew Jensen <[email protected]> ---
Created attachment 147559
--> https://bugs.documentfoundation.org/attachment.cgi?id=147559&action=edit
example database
Confirmed using Ubuntu 18.04.1, LO6.3Alpha1 and embedded firebird database.
The example file consists of an table CHECKS:
CREATE TABLE CHECKS( ID BIGINT NOT NULL PRIMARY KEY, ISSUED BOOLEAN, AMOUNT
DECIMAL(10,2));
A custom exception:
CREATE EXCEPTION EX_CHECK_ISSUED
'May not delete record for check already issued';
and the delete trigger;
CREATE TRIGGER DELETE_CHECK
ACTIVE BEFORE DELETE ON "CHECKS"
AS
BEGIN
IF (OLD."ISSUED" = TRUE) THEN
EXCEPTION EX_CHECK_ISSUED;
END;
To reproduce you can open the attached file and attempt to delete a record with
ISSUED set to TRUE form the table view, and the trigger will display an error
dialog with our custom message.
Open the form, with a grid control, and as reported the delete is blocked but
the error message is not displayed.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
