Thanks Mike

This is a good workaround, it would be real cool if that could
be displayed in a form instead of launching Adobe Reader.


Marc

----- Original Message ----- From: "MikeB" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Wednesday, February 13, 2008 5:34 PM
Subject: [RBASE-L] - RE: storing PDF files in RBase


Ok.  I tested it just to be sure and it behaves as advertised.

----- Original Message ----- From: "MikeB" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Wednesday, February 13, 2008 6:30 PM
Subject: [RBASE-L] - RE: storing PDF files in RBase




--PDF Files are of type VARBIT and can be stored just like any other type of Binary data..

--untested:

 set var vFile VarBit = ['SomePathName\SomePDFFile.pdf']

insert into myVarBitTable ColFileName, ColVarBitValue Values 'SomePDFFile' , .vFile


--To Retrieve it:

Select ColVarBitValue into vFile ind Vin0 from myVarBitTable wher ColFileName = 'SomePDFFile'

write .vFile to SomeDiskFileNameEndingInPDF.pdf

launch SomeDiskFileNameEndingInPDF.pdf


----- Original Message ----- From: "Dan Goldberg" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Wednesday, February 13, 2008 6:10 PM
Subject: [RBASE-L] - RE: storing PDF files in RBase


I have not figured it out yet. If you do please post your findings. I have
requested it as an enhancement to RBTI.

Right now we just convert them to jpegs and store them.

I currently store over 3000 images in my database now as jpegs. It works
really good for me.

Maybe it will be implemented in Rbase Nitro(V-9)??

Dan Goldberg

-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Marc
Sent: Wednesday, February 13, 2008 2:33 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - storing PDF files in RBase

Hi

I am trying to make a database to store all sorts records. Some are scanned
PDF files, some are PDF files peole send me and others are Word files,
BMP... and a few other file types.

So far I have not been able to figure out a way to store the PDF files in RBase. I know I can just save a link to the file and launch Adobe Reader but I am trying to store everything in the DB. There will only be 200-300
files total.

I keep thinking the answer us under my nose but can't seem to find it..
the answer that is not my nose.

Thanks for any suggestions
Marc










Reply via email to