Skip to main content
Nintex Community Menu Bar

Blank Smartforms controls enter "scnull" value when executing Stored procedure

  • December 28, 2016
  • 0 replies
  • 3 views

Forum|alt.badge.img+10


 

Symptoms


When executing a Stored procedure that creates an entry in a table from a form, if controls that are used as input values are blank, it enters the value "scnull" instead of NULL. This causes extra unnecessary data to be stored in the table.
 

Diagnoses


When a stored proc has return properties the broker will describe it as a list method. The return "scnull" properties were not handled correctly by the broker.
 

Resolution

A fix is available from K2 support for this issue.