[DUG] Blob primer

[Phil Middlemiss]

Ah, exactly what I was after! I was about to change over to an TIBQuery, 
but now I won't.
Thanks.

Cheers,
Phil.

Trevor Jones wrote:

>Insert into mytable(myid,myblobfield)
>Values(:id,:blob)
>
>If using a TIBSQL:
>  Sql.params[0].asInteger := 3;
>  Sql.Params[1].LoadFromFile....
>  Sql.execquery
>
>There are all sorts of ways to set the value of the blob parameter.  I
>usually use asString even for binary data 'coz a string is an easy way to
>manage a block of memory just by using setlength and if necessary reference
>s[1] as the first byte.
>
>Use a negative value for subtype if the data means nothing to anyone but
>you, and the segment size is usually irrelevant.
>
>Trevor
>
>-----Original Message-----
>From: delphi-bounces at ns3.123.co.nz [mailto:delphi-bounces at ns3.123.co.nz] On
>Behalf Of Phil Middlemiss
>Sent: Friday, 1 July 2005 8:24 a.m.
>To: NZ Borland Developers Group - Delphi List
>Subject: [DUG] Blob primer
>
>Could anyone give me a link to a "how-to" about blobs? I'm using D6 with
>firebird - there is no GUI (it's a service) so I would like to just use SQL
>if possible.
>
>Having not used blobs before I'm wondering:
>- what is a subtype? The Interbase documentation assumes you know
>- what is a good size for the segment length
>- how to specify binary data in a sql - if it's actually possible.
>- if I can't just use sql then what's the best way?
>
>Phil.
>
>_______________________________________________
>Delphi mailing list
>Delphi at ns3.123.co.nz
>http://ns3.123.co.nz/mailman/listinfo/delphi
>
>
>_______________________________________________
>Delphi mailing list
>Delphi at ns3.123.co.nz
>http://ns3.123.co.nz/mailman/listinfo/delphi
>
>
>
>  
>