Subject | Deleting BLOBs |
---|---|
Author | David Russell |
Post date | 2003-12-01T09:23:32Z |
Hi all,
We have a Delphi C/S App which makes extensive use of BLOBs.
I need to regularly clear out the records where BLOBs are blank. A SQL
statement such as:
Delete from BLOBTABLE where (BLOBFIELD is null) OR (BLOBFIELD = '')
Does NOT work. How would I go about this?
Thanks in advance
[Non-text portions of this message have been removed]
We have a Delphi C/S App which makes extensive use of BLOBs.
I need to regularly clear out the records where BLOBs are blank. A SQL
statement such as:
Delete from BLOBTABLE where (BLOBFIELD is null) OR (BLOBFIELD = '')
Does NOT work. How would I go about this?
Thanks in advance
[Non-text portions of this message have been removed]