Re: [sqlite] Foreign key support in Sqlite

- From: "Roger Andersson" <r...@telia.com> To: "'General Discussion of SQLite Database'" <sqlite-users@sqlite.org> Sent: Sunday, January 03, 2010 4:10 PM Subject: Re: [sqlite] Foreign key support in Sqlite > -Ursprungligt meddelande- >

Re: [sqlite] Foreign key support in Sqlite

; <sqlite-users@sqlite.org> Sent: Sunday, January 03, 2010 4:04 PM Subject: Re: [sqlite] Foreign key support in Sqlite >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 da

Re: [sqlite] Foreign key support in Sqlite

> -Ursprungligt meddelande- > Från: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] För Luciano de Souza > Skickat: den 3 januari 2010 19:05 > Till: General Discussion of SQLite Database > Ämne: Re: [sqlite] Foreign key support in Sqlite >

Re: [sqlite] Foreign key support in Sqlite

d follows being added contrarily the foreign key constraint. - Original Message - From: "Jean-Christophe Deschamps" <j...@q-e-d.org> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Sunday, January 03, 2010 2:51 PM Subject: R

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

Re: [sqlite] Foreign key support in Sqlite

Luciano de Souza wrote: > Everything downloaded correctly, but there is still something wrong. http://www.sqlite.org/foreignkeys.html#fk_enable http://www.sqlite.org/pragma.html#pragma_foreign_keys Igor Tandetnik ___ sqlite-users mailing list

Re: [sqlite] Foreign key support in Sqlite

the constraint. What am I doing wrong? - Original Message - From: "Jean-Christophe Deschamps" <j...@q-e-d.org> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Sunday, January 03, 2010 2:09 PM Subject: Re: [sqlite] Foreign key su

Re: [sqlite] Foreign key support in Sqlite

Hi, >I am trying to migrate to Sqlite3.6.21. I visited the Sqlite site and >downloaded the compiled file. I'm surprised in verifying that the zip >only had the executable. I hoped to find also the DLL. I bet you downloaded this: http://www.sqlite.org/sqlite-3_6_21.zip This is the CLI, he

[sqlite] Foreign key support in Sqlite

Hello listers, I am trying to migrate to Sqlite3.6.21. I visited the Sqlite site and downloaded the compiled file. I'm surprised in verifying that the zip only had the executable. I hoped to find also the DLL. Well, since I could not find the DLL file concerning this version, I presumed DLL

[sqlite] Foreign key support

Hi, I know there is no real support for foreign keys, but I read about the genfkey tool in the shell. This is probably based on the fk tool from Cody Pisto that I am also using. I added support to use the fk source as library in my code to rewrite DDL statements on the

Re: [sqlite] Foreign key support

Hi Dan, >> According to the readme: >> http://www.sqlite.org/cvstrac/fileview?f=sqlite/tool/genfkey.README >> I should be able to run genfkey directly from within the command >> line tool, but it doesn't seem to work > The change to add the genfkey functionality to the shell is still in >

Re: [sqlite] Foreign key support

On Mar 5, 2009, at 10:25 AM, BareFeet wrote: > Hi all, > >>> It is true that triggers can be used to achieve referential >>> integrity. >>> However you don't have to hand craft them. > >>> the SQLite team has already done all the work for you. The SQLite >>> source includes a program named

Re: [sqlite] Foreign key support

Hi all, >> It is true that triggers can be used to achieve referential >> integrity. >> However you don't have to hand craft them. >> the SQLite team has already done all the work for you. The SQLite >> source includes a program named 'genfkey' that will create the >> triggers. > So the

Re: [sqlite] Foreign key support

On Jan 31, 2009, at 12:25 AM, Adam DeVita wrote: > Good day, > > If I write into the sqlite3 using the analyzer: > > create table mysns (SN int primary key, desc text); > insert into mysns (SN, desc) values (1,2); > create table t2 (mynum int, desc2 text, SN references mysns(SN) ); > > insert

Re: [sqlite] Foreign key support

On Fri, Jan 30, 2009 at 11:25 AM, Adam DeVita wrote: > Good day, > > If I write into the sqlite3 using the analyzer: > > create table mysns (SN int primary key, desc text); > insert into mysns (SN, desc) values (1,2); > create table t2 (mynum int, desc2 text, SN references

[sqlite] Foreign key support

Good day, If I write into the sqlite3 using the analyzer: create table mysns (SN int primary key, desc text); insert into mysns (SN, desc) values (1,2); create table t2 (mynum int, desc2 text, SN references mysns(SN) ); insert into t2 (mynum, desc2, SN) values (1,"two", 3); This insert didn't