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-20-2023 09:57 PM
Thank you @darshthakkar
02-20-2023 08:41 PM
02-20-2023 10:01 PM
One thing i faced with all the tries is it is showing common error “Batch operation failed” i still dont know why this error is throwing,
So i have used Pipeline execute snap and updating the record in child pipeline then it is working fine.
Iam thinking the problem is with Batch operation Previously i tried with single record it worked fine.
You guys know why this error throwing Or the Mysql execute snap does not support batch operation iam confused
02-20-2023 10:28 PM
In your query, whatever string values you have pls quote them. If Set has string value then say Error_reason=‘$Error_reason’. And if where has string value then do WHERE Customer_ID=‘$Customer_ID’.
02-21-2023 03:00 AM
Thank you for reply @smudassir
I tried with this scenario also but still it is throwing error