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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
