Help get this topic noticed by sharing it on Twitter, Facebook, or email.

OLE error updating object with 3dot notation.

I'm getting an error using the 3dot notation updating a custom object.

update ENTDev...Case_Assignment_Rule__c
set Email_Address__c = Email_Address__c + '.dev'
where Email_Address__c not like '%.dev'

The error is

OLE DB provider "DBAmp.DBAmp" for linked server "ENTDEV" returned message "Error 1 : Value does not exist or does not match filter criteria.".
Msg 7343, Level 16, State 4, Line 44
The OLE DB provider "DBAmp.DBAmp" for linked server "ENTDEV" could not UPDATE table "[ENTDEV]...[Case_Assignment_Rule__c]".
1 person has
this question
+1
Reply