for sqlite itself :
As stated in the second question of my first message, shouldn't there be
some check in sqlite that the type in the constraints are compatible with
the fields, with an error at table creation?
2015-08-17 17:56 GMT+02:00 Simon Slavin :
>
> On 17 Aug 2015, at 4:50p
The missing space is a copy paste error. And the table IS getting created.
Only the insertion fails. sqlite return code is 19 (/* Abort due to
constraint violation */).
> SQLite has no such type
I see nothing in Qt code that converts BOOLEAN in NUMERIC or anything else.
The statement is passed a
, and no error is
'forgotten' by Qt at table creation.
2015-08-17 14:12 GMT+02:00 Olivier Barthelemy :
> Hi,
>
> I have been using sqlite through Qt.
>
> I have been using for a while the boolean constraint "CHECK
> (varname='true' OR varname='false
Hi,
I have been using sqlite through Qt.
I have been using for a while the boolean constraint "CHECK (varname='true'
OR varname='false')" when creating tables with boolean fields and had no
issues in Qt 4.8.6 (sqlite 3.7.7.1)
Now i am trying to port to Qt 5.4.2 (sqlite 3.8.6).
I can load alread
4 matches
Mail list logo