I can't comprehend! I downloaded the two packs in c:\test. Three files were
unpacked: sqlite3.exe, sqlite3.dll and sqlite3.def.
I created the database:
c:> sqlite3 test.db
I create the structure:
sqlite> .read test.sql
The test.sql contains the statements mentioned before.
I tried to insert a further illegal record:
sqlite> insert into people(name, cities_id) values('Pedro', 14);
The record is added without problems!
I tried:
select sqlite_version();
The answer is:
3.6.21
I had placed the three files in the current folder, but to make sure old
versions in the environment paths don't be enabled by accident, I removed
another version in c:\windows. I don't have reasons to believe the version I
downloaded is currently working. In the folder, I have:
test.sql
test.db
sqlite3.dll
sqlite3.exe
sqlite3.def
Unfortunately, the answer didn't change and the record follows being added
contrarily the foreign key constraint.
----- Original Message -----
From: "Jean-Christophe Deschamps" <[email protected]>
To: "General Discussion of SQLite Database" <[email protected]>
Sent: Sunday, January 03, 2010 2:51 PM
Subject: Re: [sqlite] Foreign key support in Sqlite
>
>>create table cities
>>(
>>id integer primary key not null,
>>name text not null
>>);
>>
>>create table people
>>(
>>id integer primary key not null,
>>name text not null,
>>cities_id integer not null,
>>foreign key(cities_id) references cities(id)
>>);
>>
>>insert into cities(name) values('Campos');
>>insert into cities(name) values('Araraquara');
>>insert into cities(name) values('Porto');
>>insert into cities(name) values('Curitiba');
>>insert into people(name, cities_id) values('John', 3);
>>insert into people(name, cities_id) values('Mary', 2);
>>
>>Regarding cities don't have the Id = 8, this statement should fail:
>>insert into people(name, cities_id) values('Pedro', 8);
>
> This last insert fails here (3.6.21) with constraint violation.
>
> Can you check which version you're actually running:
>
> select sqlite_version();
> 3.6.21
>
>
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
