RE: [DUG] size of a blob

[Witherden, Stephen]

Title: Message

Doh, I am getting slow in my old age..   Try the DATALENGTH( ) function in the database. It works in SQL server and should work in most modern databases.   Stephen -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Paul McKenzie Sent: Friday, 20 August 2004 3:07 p.m. To: NZ Borland Developers Group - Delphi List Subject: Re: [DUG] size of a blob To use a TBlobField You would have to get the dataset populated first - then you can look at the size...   To do this in SQL ... I do not know how to get the size (FireFox or Interbase) unless you create a UDF.   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:51 PM Subject: RE: [DUG] size of a blob How should I use that? The following does NOT work! (illegal command) - btw I'm using FireFox   select name from CONFIG_ITEMS where image.size >0       -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul McKenzie Sent: Friday, 20 August 2004 2:25 p.m. To: NZ Borland Developers Group - Delphi List Subject: Re: [DUG] size of a blob I just noticed a TBlobField has a size property...   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

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