K2: read varbinary field and assign to file control

  • 13 June 2021
  • 1 reply
  • 27 views

Hi,

 

I have a varbinary(MAX) field in a SQL table; I created a smartobject in K2; but this field is not listed. Please advise a way to read this varbinary field and assign to a file control in K2.

 

Thanks,

 

Sreeja


1 reply

Userlevel 5
Badge +13

Do you have control over your database? If so, try changing the data type to varchar(MAX) instead of varbinary(MAX). Then, in your SmartObject, when you create a property that maps to this field change it from Memo to File.

Reply