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 <slav...@bigfraud.org> > > On 6 Apr 2012, at 1:50pm, Matjaž Cof <nov...@svetiduh.si> 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 > 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