show blob like pdf icon

(4 posts) (2 voices)

Tags:

  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.