Sounds too complicated for this simple situation...
Can anything be done w/o coding?
On Nov 14, 2007 3:53 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> 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');
>
> Prepare a single statement of the form
>
> INSERT INTO sometable VALUES (?);
>
> Then read your file and from each line extract the actual string value,
> without quotes and with \r and \n replaced by actual CR and LF
> characters. Bind this string to the parameter of the statement
> (sqlite3_bind_text), call sqlite3_step and sqlite3_reset. Repeat for
> each line.
>
> Igor Tandetnik
>
>
>
> -----------------------------------------------------------------------------
> To unsubscribe, send email to [EMAIL PROTECTED]
>
> -----------------------------------------------------------------------------
>
>
