Apache OpenOffice Community Forum

Posted: **Sat May 23, 2020 8:37 am**

Hi,

Is it possible to use a BEFORE DELETE Trigger in an HSQL2.5 backend based on a particular criteria and display a messagebox that this record can not be deleted and leaving the record(s) in place?

Example ... any invoice where payment > 0 can not be deleted

Thanks

Posted: **Sat May 23, 2020 9:13 am**

Referencial integrity does that by default. Having a 1-n relation between a table of payments (n) and a table of invoices (1) you can not delete any invoice having an entry in the payments table.

Posted: **Sat May 23, 2020 3:01 pm**

gkick wrote:Is it possible to use a BEFORE DELETE Trigger in an HSQL2.5 backend based on a particular criteria and display a messagebox that this record can not be deleted and leaving the record(s) in place?

Example ... any invoice where payment > 0 can not be deleted

Yes.

Posted: **Sat May 23, 2020 5:34 pm**

Thanks gentlemen!

Apache OpenOffice Community Forum

[Solved] Help preventing deletion in a table or form via Tri

[Solved] Help preventing deletion in a table or form via Tri

Re: Help with preventing deletion in a table or form via Tri

Re: Help with preventing deletion in a table or form via Tri

Re: Help with preventing deletion in a table or form via Tri