Your response for by Question
2. above, is not what I was asking for ( and I understand the confusion ).
While you are using LibreOffice Version 5.3.3.2 , the database back-end that Base is using is not clear to me. The default, included database back-end, as the date I am writing this, with both OpenOffice and LibreOffice is
HSQL 1.8.0.10 and, the
CREATE TRIGGER command as you wrote it, is
NOT supported.
If, on the other hand, you have upgraded your database back-end to
HSQL 2.x or above ( as of today, the current release of
HSQL is
2.4.0 ) and this is a
SPLIT database,
NOT and
Embedded database . . . you can issue the
CREATE TRIGGER command.
To determine your HSQL database version . . . please refer to the link below, the entry by
Sliderule :
viewtopic.php?f=13&t=82854&p=384062&hil ... ll#p384062
I hope this helps, please be sure to let me / us know.
Sliderule
Thanks to add
[Solved] in your
1st post Subject (edit button top right) if this issue has been resolved.