Re: [sqlite] detect a flaw

2011-03-24 Thread Shalom Elkin
Igor, Well, libversion is 3003006 Ok. Now I'll start looking for a reason I am using an older library... Thanks, Shalom On Thu, Mar 24, 2011 at 3:51 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > Shalom Elkin <shalom.el...@gmail.com> wrote: > > I use 3.7.

Re: [sqlite] detect a flaw

2011-03-24 Thread Shalom Elkin
I use 3.7.5 , and Linux (centos). On Thu, Mar 24, 2011 at 12:56 PM, BareFeetWare <list@barefeetware.com>wrote: > On 24/03/2011, at 4:41 PM, Shalom Elkin <shalom.el...@gmail.com> wrote: > > > Sorry - it doesn't work. > > sqlite3_exec with the pra

Re: [sqlite] detect a flaw

2011-03-24 Thread Shalom Elkin
I am ready to rebuild sqlite3 with the foreign_key support enabled as default. to do this, I should UNDEFINE SQLITE_OMIT_FOREIGN_KEY. I can't find a decent way to do this undef. I use g++ on linux. Thanks, Shalom On Thu, Mar 24, 2011 at 7:41 AM, Shalom Elkin <shalom.el...@gmail.com>

Re: [sqlite] detect a flaw

2011-03-23 Thread Shalom Elkin
ragma returns |(null)| |insert into activity values (1,"play")| - should succeed : 0,|(null)|=>|not an error| |insert into activity values (3,"eat")| - should fail : 0,|(null)|=>|not an error| [shalom@pato sqlite]$ sqlite3 tik "select * from activity" 1|play 3|e

Re: [sqlite] detect a flaw

2011-03-23 Thread Shalom Elkin
ly mandated to tools like sqlite3. Or special purpose C++ hacks. Thanks, guys. Shalom On Thu, Mar 24, 2011 at 1:48 AM, BareFeetWare <list@barefeetware.com>wrote: > On 24/03/2011, at 2:50 AM, Shalom Elkin wrote: > > > I appreciate the input. Some of the advice comes obv

Re: [sqlite] detect a flaw

2011-03-23 Thread Shalom Elkin
foreign_key support on, the insert with the erronous id will just slip in. Thanks, Shalom On Wed, Mar 23, 2011 at 5:24 PM, BareFeetWare <list@barefeetware.com>wrote: > On 23/03/2011, at 9:03 PM, Shalom Elkin wrote: > > > I am new to SQLITE. Here's the challenge: >

Re: [sqlite] detect a flaw

2011-03-23 Thread Shalom Elkin
t 11:27am, Igor Tandetnik wrote: > >> Shalom Elkin<shalom.el...@gmail.com> wrote: > >>> id 3 doesn't exist, the insertion fails. Now, this was easy. what if > >>> ac.inhad millions of rows? I am looking for some way to get a message > >>> l

[sqlite] detect a flaw

2011-03-23 Thread Shalom Elkin
I am looking for some way to get a message like "error in line 3: foreign key mismatch". preferably, the import would go on without actually inserting, but report ALL errors in one pass. Any ideas? Thanks -- Shalom Elkin ___ sqlite-users