Marc, I'm sure that you'll have no problem in R:Base with the documents stored in your database.
What might become a hassle, however, is that your backups/reloads will take longer and longer as the db size grows. Is it possible to create a number of standard paragraphs/phrases and then create your instructions with R:Base reports so that you don't need to store the documents themselves? Regards, Alastair. ----- Original Message ----- From: MDRD To: RBASE-L Mailing List Sent: Wednesday, April 29, 2009 4:58 PM Subject: [RBASE-L] - RE: Instruction files in table Thanks Dan I will have about 10,000+ "notes" in varchar per year and could end up with 100,000 or more over the years. Marc From: Dan Goldberg Sent: Wednesday, April 29, 2009 10:49 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Instruction files in table As long as the database size does not matter it is okay. I have currently over 4,000 images stored in a table without any problems. Dan Goldberg ------------------------------------------------------------------------------ From: [email protected] [mailto:[email protected]] On Behalf Of MDRD Sent: Wednesday, April 29, 2009 8:41 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Instruction files in table Is there a problem with the RB4 file growing immensely? I plan on storing aprox 300-500 notes a week in a Varchar field. The notes will be from 2k to 10k. Thanks Marc From: Emmitt Dove Sent: Wednesday, April 29, 2009 10:16 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Instruction files in table Jim, You can use a VARBIT column to store the Word docs, but your file 4 will grow immensely. If you're talking about a lot of documents, store them in a subfolder and, within R:BASE, just store the path to the doc. Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Wednesday, April 29, 2009 10:27 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Instruction files in table I have many WORD documents that are instructions that go with the products we ship. At present we can print them from a form I created that uses the LAUNCH command. Can I import these documents into a table within RBASE and if I can what data type would I use? Jim I am using the latest version of 7.6. ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.287 / Virus Database: 270.12.8/2086 - Release Date: 04/29/09 06:37:00
