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