Re: [DUG] size of a blob

[Paul McKenzie]

Title: Message

This is what the TBlobField does for size - Note: this is a protected function...   function TBlobField.GetBlobSize: Integer; begin   with DataSet.CreateBlobStream(Self, bmRead) do     try       Result := Size;     finally       Free;     end; end; Regards Paul McKenzie SMSS Ltd. Wellington New Zealand ----- Original Message ----- From: JC To: 'NZ Borland Developers Group - Delphi List' Sent: Friday, August 20, 2004 2:08 PM Subject: RE: [DUG] size of a blob No, 'where image is null' doesn't seem to detect an empty blob!   Any other ideas?     -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul McKenzie Sent: Friday, 20 August 2004 1:08 p.m. To: NZ Borland Developers Group - Delphi List Subject: Re: [DUG] size of a blob Can you test for Null...   Regards Paul McKenzie SMSS Ltd. Wellington New Zealand ----- Original Message ----- From: JC To: DUG Sent: Friday, August 20, 2004 12:34 PM Subject: [DUG] size of a blob Hi all,   Is there any way of getting a query result where the size of a blob field ('image' in this case) is larger then 0?   Thus something like:   select name from CONFIG_ITEMS where size(image) >0       TIA, John _______________________________________________ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi _______________________________________________ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi

_______________________________________________
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi