Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 3 of 3 total |
How to Empty a blob! |
Tue, Mar 14 2006 6:25 PM | Permanent Link |
Dale Derix | 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 |
Tue, Mar 14 2006 6:32 PM | Permanent Link |
Steve Forbes Team Elevate | 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 |
Wed, Mar 15 2006 6:48 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Wednesday, May 15, 2024 at 08:40 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |