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]
-----------------------------------------------------------------------------
