Null Values from SQL SmartObjects are being converted to zero

  • 16 February 2021
  • 0 replies
  • 15 views

Userlevel 4
Badge +16




 








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.




Issue



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

Symptoms



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".

Resolution



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



Image



 










0 replies

Be the first to reply!

Reply