Subject Re: [IBO] How to save a PDF stored in a blob column to a file?
Author mitch_landor
--- In IBObjects@yahoogroups.com, "Martijn Tonies" <m.tonies@...> wrote:
>
>
>
>
> > 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?
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB,
Oracle &
> MS SQL Server
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>

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?