1. 

   mfiorentino, Member

   Hi,
   I have a column with blob type values. I would like to display an icon and when I click on it I must open a pdf by reading the blob. It's possible?

   Thank you
2. 

   myDBR Team, Key Master

   You have the the PDF document stored in a blob column?

   --
   myDBR Team
3. 

   mfiorentino, Member

   yes
4. 

   myDBR Team, Key Master

   If you update to the latest build, there is a command dbr.blob for this:

   01.create procedure sp_DBR_download_file( in_id int )

   02.begin

   03. 

   04.select 'dbr.blob', 'pdf', 'document.pdf';

   05. 

   06.select data

   07.from pdf_files

   08.where file_id = in_id;

   09. 

   10.end

   And the report showing the download link is a normal linked report:

   01.create procedure sp_DBR_download_file ( in_id int )

   02.begin

   03. 

   04.select 'dbr.report', 'sp_DBR_download_file', '[Link]', 'in_id=file_id';

   05. 

   06.select file_id, file_descriptiom as 'Link'

   07.from pdf_files;

   08. 

   09.end

   --
   myDBR Team

Reply

You must log in to post.