What’s the recommended data type to create to handle boolean fields, so they can be most easily referenced in a method?
I’m guessing integer, but I’m (obviously) new to Servoy and SQL.
We are using integers. A 1 is “true”, everything else (NULL, “0”) is false. In a Servoy method you can simply ask
if (column)
to check for the 1.
Additional Information:
if(column)
{
}
Will evaluate to TRUE for NOT NULL and NOT EMPTY.