Subject | Re: [ib-support] Using Blobs and Delphi |
---|---|
Author | Jason Wharton |
Post date | 2001-06-11T18:26:31Z |
Care must be taken when dealing with BLOB columns as input parameters. Are
you passing what will end up as the contents of the BLOB or the ID of the
BLOB. In IBO, if you are using input parameters and BLOB's it will get a new
BLOB_ID as needed. If you end up with a BLOB_ID used in more than one place
in the database things will be fine until one of the records referring to it
are deleted. The BLOB is released and garbage collected. Then, when one of
the other references that had the BLOB_ID get accessed it will either return
erroneous data or an Invalid BLOB ID error. In short, the BLOB will be gone.
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
you passing what will end up as the contents of the BLOB or the ID of the
BLOB. In IBO, if you are using input parameters and BLOB's it will get a new
BLOB_ID as needed. If you end up with a BLOB_ID used in more than one place
in the database things will be fine until one of the records referring to it
are deleted. The BLOB is released and garbage collected. Then, when one of
the other references that had the BLOB_ID get accessed it will either return
erroneous data or an Invalid BLOB ID error. In short, the BLOB will be gone.
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com