Clemens, Thank you for clearing that up.
On Sun, Dec 1, 2013 at 8:55 AM, Clemens Ladisch <clem...@ladisch.de> wrote: > 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 > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
