QSqlField discovery auto_increment int value

[wysota]

How is the code you posted above related to the problem?

Did you check that the query is valid using QSqlQuery::isValid()?

[patrik08]

How is the code you posted above related to the problem?

Did you check that the query is valid using QSqlQuery::isValid()?

QSqlQuery::isValid() is valid true
QSqlRecord::requiredStatus() is true
only QSqlRecord::isAutoValue() is every time false on all field auto_increment mysql or index from sqlite.... http://doc.trolltech.com/4.2/demos-s...owser-cpp.html

[wysota]

What happens if you pass NULL as a value to that field? Does the database generate a correct record for it? I think isAutoValue() will return true only if you first use QSqlField::setAutoValue().

[patrik08]

What happens if you pass NULL as a value to that field? Does the database generate a correct record for it? I think isAutoValue() will return true only if you first use QSqlField::setAutoValue().

i need only to discover a clean shema from odbc driver mysql , access , sqlite ... ecc

if table is so.....

CREATE TABLE `BASE_0` (
  `ID` int(22) NOT NULL auto_increment,
  `LANGUAGE` varchar(100) default NULL,
  `PREFIX` varchar(55) default NULL,
  `TITLE` varchar(150) default NULL,
  `NAME` varchar(100) default NULL,
  `FIRST_NAME` varchar(110) default NULL,
   PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `BASE_0` (
  `ID` int(22) NOT NULL auto_increment,
  `LANGUAGE` varchar(100) default NULL,
  `PREFIX` varchar(55) default NULL,
  `TITLE` varchar(150) default NULL,
  `NAME` varchar(100) default NULL,
  `FIRST_NAME` varchar(110) default NULL,
   PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

To copy to clipboard, switch view to plain text mode 

i like to discover field "ID auto_increment" but i think is impossibel to make a clean dump from table .... driver mysql give a different result shema as odbc...