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:

   create procedure sp_DBR_download_file( in_id int )
   
   begin
   
   select 'dbr.blob', 'pdf', 'document.pdf';
   
   select data
   
   from pdf_files
   
   where file_id = in_id;
   
   end
   
   

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

   create procedure sp_DBR_download_file ( in_id int )
   
   begin
   
   select 'dbr.report', 'sp_DBR_download_file', '[Link]', 'in_id=file_id';
   
   select file_id, file_descriptiom as 'Link'
   
   from pdf_files;
   
   end
   
   

   --
   myDBR Team

Reply

You must log in to post.