Alastair These are therapy notes for patients so we need to store the documents or notes. We use some canned paragraphs that you can modify to fit the patient and the rest of the notes are typed or dictated into RBase.
thanks Marc From: Alastair Burr Sent: Wednesday, April 29, 2009 12:05 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Instruction files in table 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
