It runs fine as long as it is small...
If the text in the field is longer, it seems to crash.
Any idea how to drop that stupid depth limit? Where do I specify that
option?
The official site (http://www.sqlite.org/limits.html) does not explain
this...
On Nov 14, 2007 3:53 PM, Dan Kennedy <[EMAIL PROTECTED]> wrote:
> On Wed, 2007-11-14 at 15:38 +0200, Jevgenijs Rogovs 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');
>
> Is it possible that you have mismatched quotes in the
> preprocessed script? The statement above runs fine here.
>
> Dan.
>
>
> > 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]
> > >
> > >
> -----------------------------------------------------------------------------
> > >
> > >
>
>
>
> -----------------------------------------------------------------------------
> To unsubscribe, send email to [EMAIL PROTECTED]
>
> -----------------------------------------------------------------------------
>
>
