Igor Korot wrote: > Is this a proper call to execute: > > if( sqlite3_exec( m_handle, "PRAGMA foreign_keys = OFF", NULL, NULL, 0 ) != > SQLITE_OK )
Yes. > The problem is that after successful execution of such code, I am > still getting error: > "foreign key constraint failed" when executing the "DELETE FROM ..." query. The documentation (<http://www.sqlite.org/pragma.html#pragma_foreign_keys>) says: | This pragma is a no-op within a transaction; foreign key constraint enforcement | may only be enabled or disabled when there is no pending BEGIN or SAVEPOINT. Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
