Null Values from SQL SmartObjects are being converted to zero

  • 16 February 2021
  • 0 replies
  • 52 views

Userlevel 5
Badge +20
 

Null Values from SQL SmartObjects are being converted to zero

kbt149855

PRODUCT
K2 Five
BASED ON
K2 Five (all)
TAGS
SQL
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