[Qt-interest] Adding Boolean to QSqlDriver?

3dw4rd at verizon.net 3dw4rd at verizon.net
Tue Aug 2 20:43:19 CEST 2011


Greetings,

I have an application that supports SQLite, Postgres, and Oracle.  I have a database schema that uses boolean for Postgres and Oracle but uses integer for SQLite because the latter does not have boolean.

If I had a QSqlDriver::Boolean it would be easy to test if the current driver had boolean in my delegate.  Then for SQLite I could maybe show false/true instead of 0/1.  I could use a QCheckBox or a QComboBox (which is the default for drivers which support boolean) instead of a QSpinBox with no checking.

I know I could just but a check for SQLite but I think this is more general.  Is SQLite te only one with a missing Boolean?  What If I want to use MySQL.  It would be nice to have a high level library solution.

How do other people feel about this?  Is there any chance of this happening?

Ed




More information about the Qt-interest-old mailing list