How to retrieve and open a document from a SQL blob table

  • 17 November 2020
  • 2 replies

Badge +5

I have a legacy database that I am creating a smartform front end for, for searching and viewing stored documents. Is there a way to do this with a Smart Form natively?




2 replies

Userlevel 1
Badge +2

Hi FrozenForms,

Unfortunately, to be able to retrieve information from an SQL database. You’d have to go the route of creating an advanced smartobject connected to the database and from there, add it to the Smartform.
(You will need to create a service instance for SQL on K2 Management if you have not already done it)


Kevin Zhou

Badge +5

HI Kevin Z. I routinely create advanced Smart Objects for my projects. The data is accessible, I was just wondering the best way to open the image through the form interface. The old data lists a URL to the blob/document but those don't work as such as you can imagine.