Re: [sqlite] sqlite3 python foreign key

2011-09-15 Thread Fabio Spadaro
Hi, So you get no error from the INSERT command, and you can also find the new row using SELECT ? No error for select 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

Re: [sqlite] sqlite3 python foreign key

2011-09-15 Thread Simon Slavin
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

Re: [sqlite] sqlite3 python foreign key

2011-09-15 Thread Fabio Spadaro
Hi 2011/9/15 Simon Slavin slav...@bigfraud.org 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.

Re: [sqlite] sqlite3 python foreign key

2011-09-15 Thread Simon Slavin
On 15 Sep 2011, at 4:36pm, Fabio Spadaro wrote: i just installed python 2.7.2 and the value returned by PRAGMA foreign_keys is [(0,)]; Later I will try with the tables. Can you tell whether your python installation process is installing a new version of whatever sqlite API you're using ?

Re: [sqlite] sqlite3 python foreign key

2011-09-15 Thread Kees Nuyt
On Thu, 15 Sep 2011 17:36:52 +0200, Fabio Spadaro fabiolinos...@gmail.com wrote: i just installed python 2.7.2 and the value returned by PRAGMA foreign_keys is [(0,)]; Later I will try with the tables. You can get the version of the SQLite library with SELECT sqlite_version();

Re: [sqlite] sqlite3 python foreign key

2011-09-15 Thread Simon Slavin
On 15 Sep 2011, at 7:02pm, Kees Nuyt wrote: fabiolinos...@gmail.com wrote: i just installed python 2.7.2 and the value returned by PRAGMA foreign_keys is [(0,)]; Later I will try with the tables. You can get the version of the SQLite library with SELECT sqlite_version();

Re: [sqlite] sqlite3 python foreign key

2011-09-15 Thread Fabio Spadaro
Hi. 2011/9/15 Simon Slavin slav...@bigfraud.org On 15 Sep 2011, at 4:36pm, Fabio Spadaro wrote: i just installed python 2.7.2 and the value returned by PRAGMA foreign_keys is [(0,)]; Later I will try with the tables. Can you tell whether your python installation process is installing a

Re: [sqlite] sqlite3 python foreign key

2011-09-15 Thread Simon Slavin
On 15 Sep 2011, at 9:57pm, Fabio Spadaro wrote: Sorry but I was wrong from the beginning; the result of pragma ... was wrong with python version 2.6 because each result were not processed in the same connection but different connections of database. No problem. Good luck with your project.

[sqlite] sqlite3 python foreign key

2011-09-14 Thread Fabio Spadaro
Hello. I use sqlite3 python. I followed exactly the steps to create a foreign key from the site http://www.sqlite.org/foreignkeys.html but I still can insert enter values not ​​allowed for constraint. Before I do the insert properly executed the instruction PRAGMA FOREIGN_KEYS =ON but did not

Re: [sqlite] sqlite3 python foreign key

2011-09-14 Thread Simon Slavin
On 14 Sep 2011, at 9:46pm, Fabio Spadaro wrote: Hello. I use sqlite3 python. I followed exactly the steps to create a foreign key from the site http://www.sqlite.org/foreignkeys.html but I still can insert enter values not ​​allowed for constraint. So you get no error from the INSERT