I believe, that foreign_key support is enabled by default in oosqlite when opening a database with the oosqlite class, but when using oosqlite3 CLI the foreign_keys support is OFF (0), I think the sqliteflags in the makefile needs /DSQLITE_DEFAULT_FOREIGN_KEYS=1 to get foreign_keys support in the OOsqlite3 CLI by default, to behave equal to the class.
Anonymous
Yes, you are exactly right. I hadn't thought about keeping the CLI in sync, but I should have.
I'll fix this.
Committed revision 8605. [r8605]
Related
Commit: [r8605]
The fix for this was in the ooSQLite 1.0.0.8707 (preview) release.