Skip to main content
Nintex Community Menu Bar

K2: read varbinary field and assign to file control

  • June 13, 2021
  • 1 reply
  • 77 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

Forum|alt.badge.img+15
  • Scholar
  • June 13, 2021

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.