Hey guys I’ve been having this issue in sendign a blank variable to a decimal value into SQL without UiPath drawing an error. (I haven’t written out the full, or completely correct version of the code here just enough that you can see how I’m setting up the variable in question)
“Update Set [Value_1] = '”+vMyDecimalValue+"’, [Value_2] = ‘"+vMySecondVariable+"’, [Value_3] = ‘"+vMyThirdVariable+"’"
I have it basically setup as the above which will work when the value I’m putting into SQL is not blank (so for example 43.28) but if vMyDecimalValue="" then it draws a conversion error. I’ve also tried using this in the update statement:
"Update Set [Value_1] = ‘+vMyDecimalValue+’ " – and then basically added the extra quotes in an if statement if vMyDecimalValue is not equal to “”
Any help on this?