problem while executing SQL query

[sosanjay]

hello,

i'm able to connect with db[MySql].
i'm trying to Execute the Sql Query but i'm not getting wrong result.

I want to get the number of row in the current table.

My Query is :

QSqlQuery q1("SELECT COUNT(RecordId) FROM tbl;");
    QSqlRecord rec1 = q1.record();
   QString Str = q1.value(0).toString();
    QMessageBox::information(this, tr("Count"),Str);

QSqlQuery q1("SELECT COUNT(RecordId) FROM tbl;");
    QSqlRecord rec1 = q1.record();
   QString Str = q1.value(0).toString();
    QMessageBox::information(this, tr("Count"),Str);

To copy to clipboard, switch view to plain text mode 

The result in message box is NULL.

if we run the sql query normally we get the result i.e 10;

What wrong in the query.

[Lykurg]

Try:

QSqlQuery q1("SELECT COUNT(RecordId) FROM tbl;");
if(q1.next())
  qWarning() << "sql-return:" << q1.value(0).toInt();

QSqlQuery q1("SELECT COUNT(RecordId) FROM tbl;");
if(q1.next())
  qWarning() << "sql-return:" << q1.value(0).toInt();

To copy to clipboard, switch view to plain text mode 

EDIT: and use the second parameter for the query constructor to set the database connection, to make sure you querying the right database.

[vcp]

Hi

Try this:

Note the: exec()

QSqlQuery q1("SELECT COUNT(RecordId) FROM tbl;");
q1.exec();
if(q1.next())
  qWarning() << "sql-return:" << q1.value(0).toInt();

QSqlQuery q1("SELECT COUNT(RecordId) FROM tbl;");
q1.exec();
if(q1.next())
  qWarning() << "sql-return:" << q1.value(0).toInt();

To copy to clipboard, switch view to plain text mode 

[Lykurg]

Note the: exec()

You don't need that. The doc says:

QSqlQuery::QSqlQuery ( const QString & query = QString(), QSqlDatabase db = QSqlDatabase() )
Constructs a QSqlQuery object using the SQL query and the database db. If db is not specified, the application's default database is used. If query is not an empty string, it will be executed.