On 9/29/06, Chris Gurtler <[EMAIL PROTECTED]> wrote:
A transaction has the select statements in one single string starting with a begin and ending with an end. I have a column which is a BLOB, and this may contain control characters like NULL.
Think of BEGIN and COMMIT more like state-changing commands. Once you execute a BEGIN, all future work on that connection will be inside of a transaction, until you COMMIT. They don't need to be within a single string, and your loops and sqlite3_bind_* can be used exactly the same way they are now (with the corrections noted by Igor of course). Just prepare/step a BEGIN before the loop, and a COMMIT afterward. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------