I would like to know how to pass a NULL value from a UiPath Execute Non Query activity, within the Value field of the Parameters, to a SQL Table.
Note that the Type could be a string – but the problem is, any value you put in the value box needs to be a string, or to have .tostring added?
The NULL value is not a string, I don’t want a blank cell, or 0, but actually NULL.
It can be done in the actual SQL query by using:
SET ColName = NULL
…but I’m using Parameters, so it would be
SET ColName = @ParameterName
…which would set the Value of the ParameterName argument.
I need to know what this Value field should be set to, to parse ‘NULL’ to the SQL table from UiPath.
NOTHING’ doesn’t work, and
"" just leaves blank cell.
Can anyone assist?