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

> >
> >
>
> It's sub-type 2.

Don't use sub-type 2!! It's a system defined sub-type that causes
IBO to transform the blob from binary to human readable BLR.

Are you using IBManager/Quickdesk from EMS Hitech, or have
you been using it?

> I am now trying to figure out how to use the F_BLOBSIZE UDF. I've
> never installed or used a UDF before.

It's sub-type 2, don't bother. IBO will read your blob in the wrong
way (actually, quite helpful, but you've made a mistake there :) ).

Change the subtype to 0 (= binary).

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