print simple Sqlite statement....

filipdns

Hello, I need your help for stupid thing...

I'm using Sqlite for my qt application and it's easy to print value from table with:

QSqlQuery query;
        query.prepare("SELECT rowid, data,  FROM table ");
        query.exec();
        while (query.next()) {

            QString data= query.value(1).toString();
}

that fine and easy...
But I need to make date diff and the statement is:

QSqlQuery datediff;
            datediff.prepare("SELECT julianday('now') - julianday('2007-02-02')");
            datediff.exec();

using db browser the query is working fine..

but how can I print the result?....
I try :

double dateresult = datediff.value(1).toDouble();
qDebug() << dateresult

but it's not working... nothing is printed...

Could you help me?...

filipdns

solved with add datediff.next(); :

datediff.prepare("SELECT date FROM (SELECT(julianday('now') - julianday(?)) AS date)");
            datediff.addBindValue(dateinsteng2);
            datediff.exec();
            datediff.next();
            int tsn = datediff.value(0).toInt();