Subject Re: [IBO] How to store/retrieve PDFs using IBObjects
Author Michel LE CLEZIO

I don't know how to do this, but I have the same problem, and my solution was to zip the pdf and store it into a directory...
I place the full zip filename into an field...
Like this, the database fdb file is smaller. It's more fast to access the zip… I can use what I want to work with the zip file...
I have no problème with charset into the fdb file… 
If my database is corrupted, I won't loose all...
I can modify my zip outside the database...

Plenty of advantage….

With best regards...

Le lundi 21 octobre 2019 à 15:43:05 UTC+2, Chuck Belanger phytotech@... [IBObjects] <> a écrit :


Hello All:

Could someone steer me to how I can do the following:

I would like to take a PDF file, compress/zip it and then upload to a DB
and store it compressed then when needed, decompress and view the PDF.

I found the the open source Abbrevia components have a component to
compress a stream and decompress a stream. My lack of understanding is
in how to actually move the PDF files/stream via IBObjects, particularly
DSQL, INSERT and later as a SELECT statement.

I believe I saw IB_DSQL has a CopyFromStream method, but I am not clear
on how to add to parameters in the INSERT statement, nor how to extract
the stored compressed PDF back out of the DB.

Thank you for any help or suggestions, sample code you might have,

Chuck Belanger.

This email has been checked for viruses by Avast antivirus software.