Re: [sqlite] Re: Why is there no sqlite3_exec16() method?

2007-06-11 Thread John Stanton
You can keep the prepared SQl and re-use it by using sqlite3_reset. Rob Richardson wrote: Igor, Thank you very much for your reply. My naïve impression was that sqlite3_prepare/step/finalize are used for SELECT statements, where there would be a result set one would want to step through, and

RE: [sqlite] Re: Why is there no sqlite3_exec16() method?

2007-06-11 Thread Rob Richardson
Igor, Thank you very much for your reply. My naïve impression was that sqlite3_prepare/step/finalize are used for SELECT statements, where there would be a result set one would want to step through, and that one would use sqlite3_exec() for statements where no result set is expected, such as

[sqlite] Re: Why is there no sqlite3_exec16() method?

2007-06-08 Thread Igor Tandetnik
Rob Richardson <[EMAIL PROTECTED]> wrote: Our shop writes in Visual C++ 6, and our applications are all developed with _UNICODE defined. But if we want to use sqlite3_exec(), we are forced to convert the SQL statements to single-byte characters. Why is there no sqlite3_exec16() method? Or is