> > > 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.

http://www.google.com/search?q=f_blobsize+udf&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a


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