problem with SELECT NEXTVAL

[pippo42]

Hello!

I would need to carry out a SELECT NEXTVAL but its does not work. Here is the code.

query.exec("SELECT NEXTVAL(\'mytable\');")
query.next();
cout << query.value(0).toInt() << "\n";

query.exec("SELECT NEXTVAL(\'mytable\');")
query.next();
cout << query.value(0).toInt() << "\n";

To copy to clipboard, switch view to plain text mode 

I obtain an error message saying that I am not on a valid record. Indeed, query.next() and query.exec("...") return false but with a lastError().text() empty. The function query.isSelect() also returns false.

What can I do?

Thanks!

[waynew]

What database type are you using?

I would use query.last() (not query.next())
That positions you on the query you just executed.

[pippo42]

Thanks!
Sorry for the delay. I had waited a little for a reply and then I assumed I would not get any.

Best regards

[Lesiok]

After execute query look with QSqlDatabase::lastError() and QSqlQuery::lastError() what happen.