Subject Re: [IBO] How to save a PDF stored in a blob column to a file?
Author Martijn Tonies
> > > I'm having problems understanding how to do this. I am trying like
> > > this but it doesn't work. Any help would be appreciated:
> > >
> > > // extract pdf from db & store to temp file
> > > (Datamodule5.qryCurrProjDocs.FieldByName("PDFColumn") as
> > > TBlobField).SaveToFile("TempPdfFullFileName");
> >
> > Why doesn't it work?
> When I try to read the file it gives a "corrupted" error message and
> the size is far too small, just a few bytes. If the above code should
> work then perhaps the pdf is stored incorrectly in the db, but I don't
> know how to check this. Can I check the size of the blob which is stored?

What is the sub-type of the blob?

And yes, you can check the size, but you need an "external function" or
"udf" for this.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
My thoughts:
Database development questions? Check the forum!