--- 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?
> >
> > 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.
I am now trying to figure out how to use the F_BLOBSIZE UDF. I've
never installed or used a UDF before.