| Hi All,
There seems to be something wrong with booleans when using OpenBase and ERPrototypes.
In OpenBaseManager the column type for my column says boolean:
In openisql (command line) I can query like this:
select count(*) from cliente where suspendido = true
of like this:
select count(*) from cliente where suspendido = 1
In entity modeler, if I configure my attribute using the boolean prototype from ERPrototypes as shown below, then the queries don't return the right number of rows. The update statements generated by EOF don't work either (even though they look right).
If I model my attribute as an integer then the queries work okay and the update statements issued by EOF work too. By I don't like having an Integer in my accessor methods in my EO for a boolean column. I want to use boolean.
Looking at the screenshot below, does this look like the boolean prototype is setting the fields correctly for a boolean column in OpenBase? Anybody wants to guess? Anybody using booleans in OpenBase and ERPrototypes?
|