Sam Carleton wrote: > > My .net application which uses System.Data.SQLite relies on the > foreign_keys to be enabled and recursive_trigger to be disabled. In my > searching, I found documentation on DefaultFlags_SQLiteConnection, setting > that in the appSettings. Here is what it says: >
In order to do this, you'll want to execute the PRAGMA statements against the connections that you open prior to running other SQL. The flags for the connection (primarily) control the behavior of System.Data.SQLite and they (generally) have no relation to PRAGMA statements. -- Joe Mistachkin _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
