Hi Trevor,
Thanks, that makes a big difference to the way I thought it worked.
Regards,
Chris
Trevor Talbot wrote:
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]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
