Fixed: Column treated as a boolean (Oracle)

0 votes

I see in 2018 release history that dbFront has the following feature :
Allow any Integer or Text field to be treated as a boolean

As my DB is Oracle, I have no boolean column type.
I'm usually creating such columns as NUMBER (1/0) or CHAR(1) (Y/N).

Unfortunately, it doesn't seems to fully work in dbFront (
If the column is a number, 1 are correctly displayed as true, 0 as false, but changing the value (checkbox) cause a error message during data saving.

Am I missing something ?
Maybe my column types are wrong, what is the expected Oracle column types ?
Documentation does not give detail about column subtype "Boolean".

In advance, many thanks for you help
Pierre Goaziou

in Version 1.0.12 by (240 points)
Hello Pierre, It looks like you found a bug.   I will see about fixing this shortly and get back to you.

1 Answer

0 votes
Best answer

This bug has been fixed by dbFront version

by (44.5k points)
selected by
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.
 | Minimalist Answer Theme by Digitizor Media
Powered by Question2Answer