I suppose I could try raising the limit of tree depth, or removing it
whatsoever, but how do I do that, provided that I'm doing my import like
this:
sqlite3 mydatabase.db < myhugescript.sql
Tried the -DSQLITE_MAX_EXPR_DEPTH=0 option on sqlite3 command line, but it
doesn't recognize it!
What am I doing wrong?
With best regards,
J.R.
On Nov 14, 2007 3:38 PM, Jevgenijs Rogovs <[EMAIL PROTECTED]> wrote:
> Thanks, but how do I use those?
> See, I have a huge file of INSERT statements, which look like this:
>
> INSERT INTO sometable VALUES ('blablabla\r\nyadayadayada');
>
> What I need is to import this data into SQLite database. If I change all
> \r\n occurances into the following:
>
> INSERT INTO sometable VALUES ('blablabla'||x'0A'||'yadayadayada');
>
> I'm getting "Expression tree is too large (maximum depth 1000)" error...
>
> Any ideas on how to cope with this?
>
> Thanks again!
>
> With best regards,
> J.R.
>
> On Nov 14, 2007 3:19 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
>
> > Jevgenijs Rogovs <[EMAIL PROTECTED]>
> > wrote:
> > > Could someone please assist me with the following: how do I insert a
> > > string into an SQLite database that contains a CR or LF character?
> > > C-style escapes (like \r and \n) are not working with SQLite, so how
> > > can I do this?
> >
> > Use parameterized statements - see sqlite3_prepare[_v2], sqlite3_bind_*,
> >
> > sqlite3_step et al.
> >
> > Igor Tandetnik
> >
> >
> >
> > -----------------------------------------------------------------------------
> > To unsubscribe, send email to [EMAIL PROTECTED]
> >
> > -----------------------------------------------------------------------------
> >
> >
>
