Is there a way to Update a SQL field as a NULL value?

追蹤

Gwen Wilson

• 2021年03月09日 20:46

I am using an update record activity to update a record in SQL. I need to set a number field that was previously set to a number value, to NULL. Is there a way to do that? I've entered NULL, 'NULL',  and "NULL", none work. 

 

0

• 

  Vinutha C

  • 2021年03月10日 13:00

  Hi Gwen,

  To update record with NULL value you can use "UpdateProcessData" activity. In "UpdateProcessData" activity > Process Data variable , type the word "NullValue" and in Expression, type "System.DBNull.Value". In your "Update Record" activity assign the variable ${NullValue} for the column you wanted to update NULL value.

  Please refer below screenshots for more info.

  

   

  

  Thanks.

  2

  評論操作 永久連結
• 

  Gwen Wilson

  • 2021年03月10日 18:03

  Thank you! This worked perfectly.

  0

  評論操作 永久連結
• 

  Alex Gawzgi

  • 2022年07月06日 03:21

  Is this still the way to update a record with a null value? My attempt to use this throws an exception: 

  AgilePointServerException: There was an error generating the XML document.

  The type System.DBNull was not expected. Use the XMlInclude or SoapInclude attribute to specify types that are not known statically.

  0

  評論操作 永久連結

請登入寫評論。