<{{Subtitle_Weight}} class="prominent-subhead {{Show_Subtitle}}"> {{Header_Subtitle}}

Null Values from SQL SmartObjects are being converted to zero

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.


K2 makes the value a valid null, and not the number that is seen. This is the .net DataTable object that does this.


When 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”.