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.
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
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>
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
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
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:
>
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
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
8 matches
Mail list logo