Page 1 of 1

WHERE clause of the UPDATE statement can't be transformed to SOQL.

Posted: Wed 07 Feb 2018 19:11
by bezpal
Hello!
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')
This produces an error:
WHERE clause of the UPDATE statement can't be transformed to SOQL.
At the same time I can do:

Code: Select all

UPDATE Foo
SET Boo='something'
WHERE id ='a'
Does it mean in UPDATE statement in WHERE clause "IN" is not suppored? Or am I missing something?
Thank you!

Re: WHERE clause of the UPDATE statement can't be transformed to SOQL.

Posted: Fri 09 Feb 2018 19:16
by Shalex
We have reproduced the error and are investigating the question. We will notify you about the result.

Re: WHERE clause of the UPDATE statement can't be transformed to SOQL.

Posted: Thu 15 Feb 2018 16:03
by Shalex
The bug with using the IN clause within UPDATE statements is fixed in v3.2.454: https://www.devart.com/dotconnect/sales ... story.html.