Null Values from SQL SmartObjects are being converted to zero
K2 FiveBASED ON
K2 Five (all)TAGS
This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice. This article is not considered official documentation for K2 software and is provided "as is" with no warranties.
IssueK2 makes the value a valid null, and not the number that is seen. This is the .net DataTable object that does this.
SymptomsWhen the value goes into the .net DataTable object, it sees the column as an Autonumber, and it automatically honors the identity and adds a number. This causes the "NULL" value to be converted to a "0".
To resolve this, change the “StoredProc Dataset Execution” setting on the SQL Service instance and set this to “true”. By default, this is set to “false”.