[sqlite] Composite Foreign Key constraint fails when it should not.

2010-07-28 Thread George Somers
pens often. Thanks! George Somers ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Composite Foreign Key not enforced

2010-05-17 Thread George Somers
> Fixed. See http://www.sqlite.org/src/info/dd08e5a988 and http://www.sqlite.org/src/info/636f86095e Gee! That was super FAST! Thanks a lot! George Somers ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-

Re: [sqlite] Composite Foreign Key not enforced

2010-05-17 Thread George Somers
test. I was please to see that SQLite3 was 2.5 faster than MS SQL Compact. And it is on pair with MS SQL Express (i.e. same speed). But SQLite3 is not restricted to 4Gig database! And it is much much easier to install than MS SQL Express/Server. Cool! I like it very much! Bye bye George

Re: [sqlite] Composite Foreign Key not enforced

2010-05-14 Thread George Somers
ID) REFERENCES child(childID, fatherID is enforced while doing INSERT, but not while doing DELETE! George Somers ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Composite Foreign Key not enforced

2010-05-13 Thread George Somers
; SELECT * FROM artist; Is there something I am doing wrong? Thanks! George Somers ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users