Hi Tony, Yes, that's the way I've been storing my lettres with our old database in Access..... as an external document with a link stored in a text field of the database. However, having the documents already in the database speeds up things a lot and gives the possibility to browse through the documents of one specific patient.
In my new R:base application I would like to store the documents in the database itself, and yes, i suppose that will make the database grow considerably. But if I understood the database structure well, BLOBS are not saved in the same RX file as the data. Maybe this will be less of a problem that it would have been in Access where the 2 GB limit would be critical. Aside of that I automatically create a backup copy of each document as an easy retrievable external pdf-file. Luc Delcoigne From: A.G. IJntema Sent: Monday, August 23, 2010 5:09 PM To: RBASE-L Mailing List Subject: [RBASE-L] - re: uploading .doc in rbase Hi Luc, Personally I would not store this kind of information in the database itself. It's quite easy to create a link from the database to the file management system and then you can open the file with the launch command. The benefit of this approach is a smaller database (important in case of backup / restore) but also the possibility to open a file of any kind as long as the extension is known in Windows. Tony IJntema From: [email protected] [mailto:[email protected]] On Behalf Of Luc Delcoigne Sent: maandag 23 augustus 2010 16:35 To: RBASE-L Mailing List Subject: [RBASE-L] - re: uploading .doc in rbase Hi, in my Access > Rbase conversion I have come to the point that I have to load .doc files into the varchar field of an rbase table. What would be the most elegant way to this, considering there are more than 80.000 files to upload in the table....? Luc Delcoigne
