Kurt Welgehausen wrote:
db eval {UPDATE t1 SET value=$bigblob WHERE rowid=$id}
Is this more efficient than
db eval "UPDATE t1 SET value='$bigblob' WHERE rowid=$id" ?
In particular, does it save a copy of the character data?
Yes, it does save you from making a copy of the data, which
can be significant if the data is big. It also saves you
from having to escape quotes in the data. You used to have
to do this:
regsub -all ' $bigblob '' qblob
db eval "UPDATE t1 SET value='$qblob' WHERE rowid=$id"
With the new design, the regsub step is no longer required.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
