Symptoms

Hello Dear,

Can you help me, my problem is how to retrieve binary image file from database and view it on a form in K2 smartform. Images stored in a table as a binary file. How to connect with smart object and enable it to view images. In the attachments you will find sample of table data and table design.
 

Diagnoses

Although some data types are not supported as mentioned in the below links:
http://help.k2.com/onlinehelp/k2blackpearl/userguide/4.6.9/webframe.html_ws_sql_01.html
http://community.k2.com/t5/K2-blackpearl/SQL-Column-not-importing-with-service-object-Column-Type-problem/ta-p/80353

There is a work around to handle this - but this is not supported by K2 support because it is not official-
http://www.velocity-it.com/how-to-display-an-image-from-a-database-on-a-k2-smartform/
 

Resolution

Although some data types are not supported as mentioned in the below links:
http://help.k2.com/onlinehelp/k2blackpearl/userguide/4.6.9/webframe.html_ws_sql_01.html
http://community.k2.com/t5/K2-blackpearl/SQL-Column-not-importing-with-service-object-Column-Type-problem/ta-p/80353

There is a work around to handle this - but this is not supported by K2 support because it is not official-
http://www.velocity-it.com/how-to-display-an-image-from-a-database-on-a-k2-smartform/