On 15 Sep 2011, at 9:12am, Fabio Spadaro wrote: >> So you get no error from the INSERT command, and you can also find the new > row using > SELECT ? > No error for select
If the SELECT command does not show the row then the INSERT did not work. >> Make a connection to the database. >> ssue "PRAGMA foreign_keys" and look at the value returned. >> Issue "PRAGMA foreign_keys = OFF". >> Issue "PRAGMA foreign_keys" and look at the value returned. >> Issue "PRAGMA foreign_keys = ON". >> Issue "PRAGMA foreign_keys" and look at the value returned. > all [ ] If you get blank responses from all of those then the version of SQLite you're using does not support foreign keys. But you reported your version number in your earlier post and that version of SQLite should support foreign keys. I don't not understand this. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
