A seemingly simple task, but I can't figure out how to do this.

I simply need to delete the contents of a blob field.

How?

Thanks,

Dale Derix

Hi Dale,

If you are using persistent fields you can use Clear i.e.

MyBlobField.Clear;

If using SQL, assign NULL in your SQL statement e.g.

UPDATE Messages SET Body = NULL WHERE Id = 1

HTH
--
Best regards

Steve

"Dale Derix" <dale@emerald-data.com> wrote in message
news:CE88CA82-4735-4350-97DA-4499C3DCA5D4@news.elevatesoft.com...
>A seemingly simple task, but I can't figure out how to do this.
>
> I simply need to delete the contents of a blob field.
>
> How?
>
> Thanks,
>
> Dale Derix

Dale,

<<A seemingly simple task, but I can't figure out how to do this.

I simply need to delete the contents of a blob field. >>

MyTable.FieldByName('MyBlobField').Clear;

should do the trick.

--
Tim Young
Elevate Software
www.elevatesoft.com