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
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
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.
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 ?
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();
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();
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
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.
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
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
10 matches
Mail list logo