Hi Trevor,
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.
Regards,
Chris
Trevor Talbot wrote:
On 9/28/06, Chris Gurtler <[EMAIL PROTECTED]> wrote:
I wish I could use transactions, but because I'm updating a blob I need
to do it that way. Ill check out the PRAGMA option to see if that helps.
Why does what you showed above mean you can't use transactions?
Also, that PRAGMA will mean a corrupted database if there is a crash
or power failure while you're performing operations on it, so make
sure that's acceptable.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
