Hi,
How does one set a multi field constraint like
if debit is greater then 0 then credit is 0 and if credit is greater then 0 then debit is 0
Thanks
[Solved] Setting a multifield constraint
[Solved] Setting a multifield constraint
Last edited by gkick on Sat Sep 05, 2020 9:39 pm, edited 1 time in total.
Libre Office 6.4.6 on Windows 10 HSQL 2.51 backend
Re: Setting a multifield constraint
Code: Select all
alter table "foo" add constraint "blah" check "debit"=0 OR "credit"=0
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: Setting a multifield constraint
Thank you Villeroy
Libre Office 6.4.6 on Windows 10 HSQL 2.51 backend