Re: [sqlite] Question about foreign key

2012-10-21 Thread Simon Slavin
On 21 Oct 2012, at 8:54am, Igor Korot wrote: > On Sun, Oct 21, 2012 at 12:05 AM, Simon Slavin wrote: >> >> >> The simplest thing is to use any compilation (including any you already >> have) and just make sure you use the PRAGMA immediately after opening the >> file. > > I didn't change an

Re: [sqlite] Question about foreign key

2012-10-21 Thread Igor Korot
Hi, Simon, On Sun, Oct 21, 2012 at 12:05 AM, Simon Slavin wrote: > > On 21 Oct 2012, at 7:35am, Igor Korot wrote: > >> database. In order for that to happen properly I need the >> foreing key constraint to be included. > > The simplest thing is to use any compilation (including any you already h

Re: [sqlite] Question about foreign key

2012-10-21 Thread Simon Slavin
On 21 Oct 2012, at 7:35am, Igor Korot wrote: > database. In order for that to happen properly I need the > foreing key constraint to be included. The simplest thing is to use any compilation (including any you already have) and just make sure you use the PRAGMA immediately after opening the fi

Re: [sqlite] Question about foreign key

2012-10-20 Thread Igor Korot
Hi, Keith, On Sat, Oct 20, 2012 at 11:10 PM, Keith Medcalf wrote: > On Saturday, 20 October, 2012 at 23:42, Igor Korot wrote: > >> According to http://www.sqlite.org/foreignkeys.html the FOREIGN KEY >> support is disabled by default. > > Yes, foreign key enforcement is disabled by default. OK.

Re: [sqlite] Question about foreign key

2012-10-20 Thread Keith Medcalf
On Saturday, 20 October, 2012 at 23:42, Igor Korot wrote: > According to http://www.sqlite.org/foreignkeys.html the FOREIGN KEY > support is disabled by default. Yes, foreign key enforcement is disabled by default. > In order to enable it I need to compile SQLITE with 2 defines undefined. Not

Re: [sqlite] Question about foreign key

2012-10-20 Thread Pavel Ivanov
On Sat, Oct 20, 2012 at 10:41 PM, Igor Korot wrote: > Hi, ALL, > According to http://www.sqlite.org/foreignkeys.html the FOREIGN KEY > support is disabled by default. > In order to enable it I need to compile SQLITE with 2 defines undefined. Which also undefined by default. Any SQLITE_OMIT_* defi

[sqlite] Question about foreign key

2012-10-20 Thread Igor Korot
Hi, ALL, According to http://www.sqlite.org/foreignkeys.html the FOREIGN KEY support is disabled by default. In order to enable it I need to compile SQLITE with 2 defines undefined. I downloaded the file sqlite-amalgamation-3071400.zip, unpacked it, added .c and .h file to my project and inspected