See the BlobInserts sample application for how I like to do it.

Jason Wharton
www.ibobjects.com

-----Original Message-----
From: robert_p_levy [mailto:robert_p_levy@...]
Sent: Monday, June 07, 2004 8:19 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] Passing Blobs to an Insert or Update Query


Hmmm.... I can't seem to pass blobs to an update or insert query.
Any ideas?

sQ :=
'INSERT into SIGNATURES ' +
'(SINVLOOKUP, BARCODE) Values '+
'('+ QuotedStr(sInvLookup) + ', :Barcode)';
Active := False;
SQL.Clear;
SQL.Add(sQ);
TBlobField(ParamByName('BARCODE')).LoadFromFile(sJPEGFile);
Active := True;

Thanks in advance
-Rob