At 12:55 PM 1/21/2003 -0500, Ann W. Harrison wrote:

>The documentation for InterBase 6 says that you shouldn't
>manipulate blobs in triggers and procedures. In fact,
>assigning a blob from one record to another does not cause
>any error. However, under some circumstances, that blob
>id is copied,

What she meant is: Most of the time, a second copy of
the blob is created and the id of that blob is stored in
the target record. Occasionally, rather than making a
new copy of the blob, the server just copies the blob id
from one record to the other

>so two records point to the same record on

That line should say:
so two records point to the same _blob_ on

>disk. If one of those records is deleted then the other
>record will point to nothing and will get the BLOB not found
>error. If the blob is updated through one record and the
>old version is garbage collected, you'll see the same thing.
>
>Fixed in firebird V1.0

Regards,

Ann
www.ibphoenix.com
We have answers.