Igor Tandetnik <itandet...@...> writes: [...] > > Why would you want to fail statements that end up not violating any > constraints?
The idea is to prevent that somebody can change the table staff that is not already in the table. Therefore I create the first user by not switching on foreign keys. My idea was that the constraint is violated because the PK isn't found (I assumed the INSERT/UPDATE will take place after the check). But if I take http://en.wikipedia.org/wiki/Foreign_key for granted than I misunderstood the Foreign Key concept because there are 2 different(!) tables required. Oliver _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
