| Subject | Passing Blobs to an Insert or Update Query | 
|---|---|
| Author | robert_p_levy | 
| Post date | 2004-06-08T03:18:56Z | 
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
            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