I am running the latest version. (Just starting to use SQLite and really like it). Like i sad, i don't want to write sql every time i connec't to database. And i use EntityFramework, witch means that ObjectContext doesn't have any ExecuteSql method and because of that, i try to recompile with SQLITE_DEFAULT_FOREIGN_KEYS.
2012/4/6 Simon Slavin <[email protected]> > > On 6 Apr 2012, at 1:50pm, Matjaž Cof <[email protected]> wrote: > > > But here is the problem. For foregein key i can insert any value even if > > inserted ID not exist in reference table. > > See this page > > <http://sqlite.org/foreignkeys.html> > > You must be running at least 3.6.19. And you must have > > PRAGMA foreign_keys = ON > > Simon. > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
