I’m experimenting with migration of a database to Firebird from HSQLDB. I have a personal accounting database with a boolean field “Deductible.” When filtering for reports, I want to be able to select one of the following options:
Only decuctible (Deductible field = TRUE)
Only NOT deductible (Deductible field = FALSE)
ALL records (Dedcutble field is either TRUE or FALSE)
I have a 1 record table for my filtering criteria, selecting for dates, expense category, as well as the deductible field. I use a form to update this table. A query based on the data table and the criteria table is the basis for reports.
With HSQLDB I could use integer values to filter for boolean fields, but this doesn’t seem to work in Firebird. How do I set up my criteria table and form to filter for the three options I want above? The “ALL records” option is what I don’t know how to select for.