QSQLITE problem with FOREIGN KEY

[Kangs]

hi everybody, i have a problem, when i compile such a code:

query.exec("CREATE TABLE IF NOT EXISTS ProductTypeGroup(id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT)");
query.exec("CREATE TABLE IF NOT EXISTS ProductType(id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, low_level INTEGER )");

everything is ok, the table called ProductType will be created

but when i compile such a code:

query.exec("PRAGMA foreign_keys = ON;");
query.exec("CREATE TABLE IF NOT EXISTS ProductTypeGroup(id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT)");
query.exec("CREATE TABLE IF NOT EXISTS ProductType(id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, low_level INTEGER ), FOREIGN KEY (group) REFERENCES ProductTypeGroup(id)");

i don't have any errors but table called ProductType won't be created

Do You know what can be a problem??

You have certainly errors, test the return value of QSqlQuery::exec
You foreign key is bad (not exists).