QSqlQuery read row id (SOLVED)

[josepvr]

hello,
i'm implementing a routine that reads row data from SQLITE db.
I want to read id and the other fields.
I can get other fields data correctly, but id data is null.

my code is:

QSqlQuery query("SELECT id,name FROM person");
 
        while (query.next())
        {
            qDebug(query.value(0).toString().toAscii());
            qDebug(query.value(1).toString().toAscii());
        }

QSqlQuery query("SELECT id,name FROM person");

        while (query.next())
        {
            qDebug(query.value(0).toString().toAscii());
            qDebug(query.value(1).toString().toAscii());
        }

To copy to clipboard, switch view to plain text mode 

and result is:

<-- nothing
Tom <-- first row name column value.

<-- nothing
Tom <-- first row name column value.

To copy to clipboard, switch view to plain text mode 

Can anybody help me?

[bibhukalyana]

try

int id;
id=query.record().value("id").toInt();

int id;
id=query.record().value("id").toInt();

To copy to clipboard, switch view to plain text mode 

use #include <QSqlRecord>

[josepvr]

I've solved the problem!

problem was creating table, auto increment wasn't set to id field.

query.exec("create table person(id INTEGER PRIMARY KEY AUTOINCREMENT,namevarchar(20))");

query.exec("create table person(id INTEGER PRIMARY KEY AUTOINCREMENT,namevarchar(20))");

To copy to clipboard, switch view to plain text mode 

Thanks!

[bibhukalyana]

Without auto increment you can create table .