PDA

View Full Version : Qt MySQL



weixj2003ld
30th June 2009, 15:25
When I create a table in my application with


....
create table if not exists table_name
...
UPHOLE_DEPTH float(16,1) unsigned zerofill default NULL,
....

When I insert a record into the talbe,error:
Out of range value for column 'UPHOLE_DEPTH' at row 1 QMYSQL3: unable to execute statement

nanortemis
30th June 2009, 16:22
Hi,

Please paste more code, probably it's mysql statement problem not qt,
try first the same in mysql console or mysql query browser.