cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

My sql execute snap

rjapala
New Contributor III

image
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

21 REPLIES 21

rjapala
New Contributor III

Thank you @darshthakkar

darshthakkar
Valued Contributor

@rjapala - if you have your pipeline in Dev, you may want to try @alchemizโ€™s solution, Iโ€™m sure that will work 100%.

rjapala
New Contributor III

@alchemiz @darshthakkar

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

smudassir
Employee
Employee

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โ€™.

rjapala
New Contributor III

Thank you for reply @smudassir

I tried with this scenario also but still it is throwing error