Hi 2011/9/15 Simon Slavin <[email protected]>
> > 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 > i just installed python 2.7.2 and the value returned by "PRAGMA foreign_keys" is [(0,)]; Later I will try with the tables. -- Fabio Spadaro www.fabiospadaro.com _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
