Jim, I originally stored PDFs within RBASE but quickly moved to storing them in a subdirectory outside of the database. I came up with a 4 screen system used for all PDFs that creates the file and opens a viewer to accept or reject. Accepted PDFs go to a subdirectory and stores info about the PDF in a master table. The master table feeds a DB Grid screen where the user can pick the PDF they want to print. It pops back up in a viewer for the user to check and send to a printer. It was far faster than storing the PDF in the database. I do not embed fonts so most PDFs are about 60KB but some hit 2000KB. Embeding fonts created some very large PDFs. It also saved time when rebuilding the database since RBASE does not have to mess with them. I can also easily pull up any PDF in the subdirectory with any PDF reader outside the database.
Tom Frederick President/CEO Elm City Center 1314 W Walnut Jacksonville, IL 62650 W- 217-245-9504 F - 217-245-2350 E - [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Wednesday, April 25, 2012 2:30 PM To: RBASE-L Mailing List Subject: [RBASE-L] - PDF IN RBASE Right now we run a report that goes outside of RBASE to get a PDF based on a part number. We are considering doing the same for the assembly drawings. However instead of going outside of RBASE, we are also considering bringing those PDF into a table. Is that possible and if so what data type do I use in the field that would hold the PDF? We are using 7.6. James Belisle Making Information Systems People Friendly Since 1990
