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