Maya Opperman wrote:

>
> Nope, I was worried about: (pseudo code)
>
> a- Start Transaction
> b- update StockTable small fields
> c- if New-Image-Selected then
> update same StockTable record's blob field (in a separate SQL
> statement)
> d- Commit
>

This is exactly the same as

a - start transaction
b - update StockTable field1
c - if (condition) update StockTable field2
d - if (other condition) update StockTable field1
...
commit

Updating multiple fields in the same record from one transaction
is no problem.


Good luck,


Ann