[Solved] SQLite: pragma foreign_key_check

[achronop]

I try to execute a QSqlQuery for the following pragma command (sqlite) but it does not return the expected results.

QSqlQuery q("pragma foreign_key_check")

The expected result would be to return the 4 columns table with all foreign key constrains violations. I have entered in purpose some violations but it returns an empty record (q.size() == -1). From sqlite studio I am able to see the results of this commands. no through Qt though.

Other pragma commands like "pragma foreign_key_list(tablename)" work fine.

Can anyone explain why "pragma foreign_key_check" command does not return any result when it should?

[googie]

Check if the SQLite driver in your Qt is 3.7.16 or higher, because that's the version in which this pragma was introduced. To check version execute query:

SELECT sqlite_version()

[achronop]

Thank you googie!
The problem was exactly that. I had driver version 3.6.19 and now I updated to 3.8.4.3 and the problem solved!

Just for reference the q.size() is again -1 but the violations are returned correctly.

[SGaist]

Hi and welcome to devnet,

IIRC, not all database drivers support returning query sizes. You can check with QSqlDriver::hasFeature(QSqlDriver::QuerySize);