Yes. I want too that default. But I still need it in de ODBC driver because I don't have a way to enable foreign keys with MS Access via ODBC.
> Currently the code base supports SQLITE_DEFAULT_RECURSIVE_TRIGGERS > which controls the default setting for PRAGMA recursive_triggers. > > Can someone please add similar support for a > SQLITE_DEFAULT_FOREIGN_KEYS compiler define that allows the default > setting of PRAGMA foreign_keys to be controlled at compile time? > > Just a couple of lines need to be added around line 343 of sqliteInt.h > and just a couple more around line 1621 of main.c (the flag needed > there is SQLITE_ForeignKeys). > > It's very trivial to make these changes (and I can easily do it > locally), but it would sure be nice if support for enabling foreign > keys by default could make it into the official distribution. > > Then you could just add -DSQLITE_DEFAULT_FOREIGN_KEYS=1 to the > compiler options to have foreign keys always enabled by default. > > Anyone else interested in having support for this compiler option? > > Kyle > _______________________________________________ > 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