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
[Solved] Help preventing deletion in a table or form via Tri
[Solved] Help preventing deletion in a table or form via Tri
Last edited by gkick on Sun May 24, 2020 4:29 am, edited 2 times in total.
Libre Office 6.4.6 on Windows 10 HSQL 2.51 backend
Re: Help with preventing deletion in a table or form via Tri
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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Help with preventing deletion in a table or form via Tri
Yes.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
Re: Help with preventing deletion in a table or form via Tri
Thanks gentlemen!
Libre Office 6.4.6 on Windows 10 HSQL 2.51 backend