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

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Cloud Applications
Post Reply
bezpal
Posts: 6
Joined: Tue 21 Nov 2017 17:27

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

Post by bezpal » Wed 07 Feb 2018 19:11

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!

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

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

Post by Shalex » Fri 09 Feb 2018 19:16

We have reproduced the error and are investigating the question. We will notify you about the result.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

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

Post by Shalex » Thu 15 Feb 2018 16:03

The bug with using the IN clause within UPDATE statements is fixed in v3.2.454: https://www.devart.com/dotconnect/sales ... story.html.

Post Reply