Storing PDF files in a table
Sabby
store BMP files for pictures. I was wondering if it could be possible to
store PDF files in a table? If so, how to proceed?
If it's not possible in 2.6, is it possible in 4.0?
Thanks,
--
Sebastien Aussant
Bath Fitter®
Luc Van Dyck
> We are currently using Navision 2.6 in the native databse. I know we can
> store BMP files for pictures. I was wondering if it could be possible to
> store PDF files in a table? If so, how to proceed?
>
> If it's not possible in 2.6, is it possible in 4.0?
Bitmaps are stored in the database in BLOB-fields (Binary Large Objects).
You can put all kind of files in such fields (eg: Word documents, Excel
sheets ... pdf files). Just create a BLOB-field in a table, and use the
IMPORT-function to import some file (again: all kind of files can be
imported) in it.
Syntax: myBlobField.IMPORT('*.PDF',TRUE);
When you want to view the pdf-file from inside Navision, you first need to
export the file out of the BLOB-field (using EXPORT) and then you can use the
HYPERLINK-function to call up your pdf-viewer:
Syntax: HYPERLINK('c:\temp\myfile.pdf');
For the import- en exporting of the files in BLOB-fields, you can have a
look at form 346, menuitem Picture -> Import.
Regards,
Luc Van Dyck
webmaster mibuso.com