Does anybody know how to turn on FK checking in sqlite from fp?
In the sqlite documentnation I see that
PRAGMA foreign_keys = on
has to be called every time a new connection is opened, and has not to be done within transaction.
Currently I tried this 2 ways:
1. Create sqlite connection
2. Open sqlite connection
3. ExecuteDirect('PRAGMA foreign_keys = on');
This fails saying "Transaction not set."
1. Create sqlite connection
2. Open sqlite connection
3. Create a transaction, bu do not start it
3. ExecuteDirect('PRAGMA foreign_keys = on', transaction);
This fails saying "Error: attempt to implicitly start a transaction on Connection "", transaction ""."
Thanks