c++ - Strange MySql Qt4.8 issue -


i'm trying insert qsqlrecord in empty table. field isptzonvif defined as:

isptzonvif bool not null default false 

but following error:

failed submit. column 'isptzonvif' cannot null qmysql3: unable execute statement 

if print contents of record before trying insert get:

    qsqlrecord( 27 )       " 0:" qsqlfield("id", uint, length: 10, precision: 0, required: yes, generated: yes, typeid: 3) "-1"       " 1:" qsqlfield("host", qstring, length: 150, precision: 0, required: no, generated: yes, typeid: 253) ""       " 2:" qsqlfield("port", uint, length: 10, precision: 0, required: no, generated: yes, typeid: 3) "0" ...      " 7:" qsqlfield("isptzonvif", int, length: 1, precision: 0, required: yes, generated: yes, typeid: 1) "0"   ... 

i cannot image happening here because isptzonvif has default value (represented 0 "0"). i'm using qt4.8 , mysql 5.5.52

i appreciate hint.

thanks!


Comments

Popular posts from this blog

php - How to add and update images or image url in Volusion using Volusion API -

javascript - jQuery UI Splitter/Resizable for unlimited amount of columns -

javascript - IE9 error '$'is not defined -