02-17-2023 03:42 AM
Am facing this error when am trying to update column data in SQL dynamically please can anyone give me a solution how to update with correct syntax using with expressions or without
02-17-2023 07:28 AM
You would want to enable the expression (click the =
next to the “SQL Statement” input) and then set the input field to:
"Update rakesh_sf_customer_order" +
" SET Error_reason = " + $Error_reason +
" Where Customer_ID = " + $Customer_ID + ";"
02-17-2023 01:13 PM
Agreed with @ddellsperger
@rjapala: At any point you want to use the fields of input/output schema in your “execute” snaps, you’ll have to select the “=” decorator.
And when you do that, your query which is a string needs to be put under " " quotes.
02-17-2023 10:04 PM
Thank you so much for your reply @ddellsperger and @darshthakkar
But i am facing same issue again after i toggle the = expression
02-18-2023 05:11 AM
you’ll probably have to put single quotes around the string for $Error_reason
"Update rakesh_sf_customer_order " +
"SET Error_reason = '" + $Error_reason + "' "
"Where Customer_ID = " + $Customer_ID + ";"