[DUG] Blob primer

[Trevor Jones]

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