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!