Subject Re: PDF IN TABLE From Yiannis H. Economides <yianeco@cytanet.com.cy> Date Thu, 18 Jan 2018 04:55:57 -0500 Newsgroups dbase.getting-started I agree with Ronnie's comments and actually the very big DBT file is something that forced me to apply a similar approach. But I was just pointing out that saving/reading pdf files from a table is possible. Yiannis Ronnie MacGregor Wrote: > In article <#l6CVLDkTHA.904@ip-AC1E04A7>, yianeco@cytanet.com.cy says... > > > You can easily do that by, > > a) opening a dialog window to select a file (pdf) > > b) sabe the pdf file to the table using replace binary yourtable->pdffile1 from (cfile) > > (cfile is the pdf file selected, pdffile1 is the name of the binary field to hold the info). > > > > And off course you can read the file from table using > > copy binary yourtable->pdffile1 to (cf) and then open the cf (pdf file) with a browser or other software. > > While it is entirely possible to do this, I would suggest that it is not the > best approach. > > You will end up with a very large .DBT file. > The size of this file has the potential to exceed that which can be handled. > If this file becomes damaged you stand to lose every file contained therein. > > A better approach would be to rename the pdf files as appropriate and move them > to the chosen storage directory, and this can be different for each subject > matter. > > Store the path to each storage location in a table. > > Store a list of document types in a table, along with the storage location ID > to use. > > Store the document type and the filename in a table. > > > The reasons for this approach ? . . . . . > > A change of storage directory for any document subject can be dealt with easily > by changing the stored datapath for one record in the storage locations table. > > A table of document types (subjects) makes it easy to provide a pick list of > document types for the user. > > > > -- > Ronnie MacGregor > Scotland > > Ronnie at > dBASEdeveloper > dot co dot uk > > www.dBASEdeveloper.co.uk > > >