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
Post a Comment