WHERE clause of the UPDATE statement can't be transformed to SOQL.
Posted: Wed 07 Feb 2018 19:11
Hello!
I use Devart.Data.Salesforce. I have SQL like this:
This produces an error:
Does it mean in UPDATE statement in WHERE clause "IN" is not suppored? Or am I missing something?
Thank you!
I use Devart.Data.Salesforce. I have SQL like this:
Code: Select all
UPDATE Foo
SET Boo='something'
WHERE id IN ('a','b','c','d')
At the same time I can do:WHERE clause of the UPDATE statement can't be transformed to SOQL.
Code: Select all
UPDATE Foo
SET Boo='something'
WHERE id ='a'
Thank you!