Hello.
I use a SMALLINT type column at 1 or 0 to set the status of an invoice (valid or cancelled).
INV_STATUS SMALLINT DEFAULT 1 NOT NULL, -- valid (1) or cancelled (0)
CONSTRAINT CC_INV_STATUS CHECK (VAC_STATUS BETWEEN 0 AND 1)
In the form, rather than a checkbox or listbox, I inserted a button with toggle mode.
How do I set 2 colors (eg green for 1 and red for 0), for the button based on its state?
Thanks.