<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1458" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=187501200-25082004><FONT face=Arial color=#0000ff size=2>Thank
a lot for your reply Stephen, but this DATALENGTH( ) function doesn't seem to be
available in FireFox.</FONT></SPAN></DIV>
<DIV><SPAN class=187501200-25082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=187501200-25082004><FONT face=Arial color=#0000ff
size=2>John</FONT></SPAN></DIV>
<DIV><SPAN class=187501200-25082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=187501200-25082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
delphi-bounces@ns3.123.co.nz [mailto:delphi-bounces@ns3.123.co.nz] <B>On
Behalf Of </B>Witherden, Stephen<BR><B>Sent:</B> Wednesday, 25 August 2004
11:15 a.m.<BR><B>To:</B> NZ Borland Developers Group - Delphi
List<BR><B>Subject:</B> RE: [DUG] size of a blob<BR><BR></FONT></DIV>
<DIV><SPAN class=988501323-24082004><FONT face=Arial color=#0000ff size=2>Doh,
I am getting slow in my old age..</FONT></SPAN></DIV>
<DIV><SPAN class=988501323-24082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=988501323-24082004><FONT face=Arial color=#0000ff size=2>Try
the DATALENGTH( ) function in the database. It works in SQL server and should
work in most modern databases.</FONT></SPAN></DIV>
<DIV><SPAN class=988501323-24082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=988501323-24082004><FONT face=Arial color=#0000ff
size=2>Stephen</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
delphi-bounces@ns3.123.co.nz [mailto:delphi-bounces@ns3.123.co.nz]<B>On
Behalf Of </B>Paul McKenzie<BR><B>Sent:</B> Friday, 20 August 2004 3:07
p.m.<BR><B>To:</B> NZ Borland Developers Group - Delphi
List<BR><B>Subject:</B> Re: [DUG] size of a blob<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>To use a TBlobField You would have to get the
dataset populated first - then you can look at the size...</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>To do this in SQL ... I do not know how to get
the size (FireFox or Interbase) unless you create a UDF.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>Regards<BR>Paul McKenzie<BR>SMSS Ltd.<BR>Wellington<BR>New
Zealand</DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=johnc@s4-technology.com
href="mailto:johnc@s4-technology.com">JC</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=delphi@ns3.123.co.nz
href="mailto:delphi@ns3.123.co.nz">'NZ Borland Developers Group - Delphi
List'</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, August 20, 2004 2:51
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [DUG] size of a
blob</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=390064902-20082004><FONT face=Arial color=#0000ff
size=2>How should I use that? The following does NOT work! (illegal
command) - btw I'm using FireFox</FONT></SPAN></DIV>
<DIV><SPAN class=390064902-20082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=390064902-20082004>
<DIV><SPAN class=076143200-20082004><FONT face=Arial size=2><STRONG>select
name<BR>from CONFIG_ITEMS<BR>where <SPAN
class=390064902-20082004><FONT color=#ff0000>image.size</FONT></SPAN>
>0</STRONG></FONT></SPAN></DIV></SPAN></DIV>
<DIV><SPAN class=390064902-20082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=390064902-20082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=390064902-20082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> <A
href="mailto:delphi-bounces@ns3.123.co.nz">delphi-bounces@ns3.123.co.nz</A>
[mailto:delphi-bounces@ns3.123.co.nz] <B>On Behalf Of </B>Paul
McKenzie<BR><B>Sent:</B> Friday, 20 August 2004 2:25 p.m.<BR><B>To:</B>
NZ Borland Developers Group - Delphi List<BR><B>Subject:</B> Re: [DUG]
size of a blob<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>I just noticed a TBlobField has a size
property...</FONT></DIV>
<DIV> </DIV>
<DIV>Regards<BR>Paul McKenzie<BR>SMSS Ltd.<BR>Wellington<BR>New
Zealand</DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=johnc@s4-technology.com
href="mailto:johnc@s4-technology.com">JC</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=delphi@ns3.123.co.nz
href="mailto:delphi@ns3.123.co.nz">'NZ Borland Developers Group -
Delphi List'</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, August 20, 2004
2:08 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [DUG] size of a
blob</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=468340302-20082004><FONT face=Arial color=#0000ff
size=2>No, 'where image is null' doesn't seem to detect an empty
blob!</FONT></SPAN></DIV>
<DIV><SPAN class=468340302-20082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=468340302-20082004><FONT face=Arial color=#0000ff
size=2>Any other ideas?</FONT></SPAN></DIV>
<DIV><SPAN class=468340302-20082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=468340302-20082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> <A
href="mailto:delphi-bounces@ns3.123.co.nz">delphi-bounces@ns3.123.co.nz</A>
[mailto:delphi-bounces@ns3.123.co.nz] <B>On Behalf Of </B>Paul
McKenzie<BR><B>Sent:</B> Friday, 20 August 2004 1:08
p.m.<BR><B>To:</B> NZ Borland Developers Group - Delphi
List<BR><B>Subject:</B> Re: [DUG] size of a
blob<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Can you test for Null...</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT><FONT face=Arial
size=2></FONT> </DIV>
<DIV>Regards<BR>Paul McKenzie<BR>SMSS Ltd.<BR>Wellington<BR>New
Zealand</DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=johnc@s4-technology.com
href="mailto:johnc@s4-technology.com">JC</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=delphi@ns3.123.co.nz
href="mailto:delphi@ns3.123.co.nz">DUG</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, August 20, 2004
12:34 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [DUG] size of a
blob</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=076143200-20082004><FONT face=Arial size=2>Hi
all,</FONT></SPAN></DIV>
<DIV><SPAN class=076143200-20082004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=076143200-20082004><FONT face=Arial size=2>Is
there any way of getting a query result where the size of a blob
field ('image' in this case) is larger then 0?</FONT></SPAN></DIV>
<DIV><SPAN class=076143200-20082004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=076143200-20082004><FONT face=Arial size=2>Thus
something like:</FONT></SPAN></DIV>
<DIV><SPAN class=076143200-20082004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=076143200-20082004><FONT face=Arial size=2>select
name<BR>from CONFIG_ITEMS<BR>where size(image)
>0</FONT></SPAN></DIV>
<DIV><SPAN class=076143200-20082004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=076143200-20082004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=076143200-20082004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=076143200-20082004><FONT face=Arial
size=2>TIA,</FONT></SPAN></DIV>
<DIV><SPAN class=076143200-20082004><FONT face=Arial
size=2>John</FONT></SPAN></DIV>
<P></P><FONT face=Arial size=2></FONT>
<HR>
<P></P>_______________________________________________<BR>Delphi
mailing list<BR><A
href="mailto:Delphi@ns3.123.co.nz">Delphi@ns3.123.co.nz</A><BR><A
href="http://ns3.123.co.nz/mailman/listinfo/delphi">http://ns3.123.co.nz/mailman/listinfo/delphi</A><BR></BLOCKQUOTE></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>Delphi
mailing
list<BR>Delphi@ns3.123.co.nz<BR>http://ns3.123.co.nz/mailman/listinfo/delphi<BR></BLOCKQUOTE></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>Delphi mailing
list<BR>Delphi@ns3.123.co.nz<BR>http://ns3.123.co.nz/mailman/listinfo/delphi<BR></BLOCKQUOTE></BLOCKQUOTE><BR>
<P><FONT size=2>---<BR>Incoming mail is certified Virus Free.<BR>Checked by
AVG anti-virus system (http://www.grisoft.com).<BR>Version: 6.0.742 / Virus
Database: 495 - Release Date: 19/08/2004<BR></FONT></P>
<P><FONT face=Arial size=2></FONT></P></BLOCKQUOTE></BODY></HTML>