Hi Craig,
>I have been using "LoadFromFile" in my Delphi apps to load a pdf file into
>my Firebird databases. However, I need to replicate this using an update
>query.
>The code below was my first attempt. Using IBOjects within Delphi
> qryUpdateManifestBLOB.SQL.Clear;
> qryUpdateManifestBLOB.SQL.Add('UPDATE');
> qryUpdateManifestBLOB.SQL.Add('w_shipments');
> qryUpdateManifestBLOB.SQL.Add('SET');
> qryUpdateManifestBLOB.SQL.Add('w_shipments.US_manifest_doc =');
> qryUpdateManifestBLOB.SQL.Add('LoadFromFile');
Well, this obviously won't work, because whatever is in the .SQL property,
is executed by the Firebird database engine. And that engine cannot execute
Delphi code.
Use a parameter:
SQL.Add('SET myblobcol = :newblob');
and of course the primary key stuff.
Call:
qryUpdateManifestBLOB.Prepare;
qryUpdateManifestBLOB.ParamByName('newblob').LoadFromFile
qryUpdateManifestBLOB.ExecSQL;
>which Firebird did not like because "LoadToFile" is an unknown function.
See above.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
