You’re offline. This is a read only version of the page.
270
Hello,
Is there a way in CRM to do an Update like with we do in sql sesrver :
Share
ReportUPDATE account
SET attribute1 = value1
WHEN attribute2 > value2 Thank you in advance.
*This post is locked for comments
You can either do it using SSIS and KingswaySoft CRM Connector, or you can create an external application, retrieve the records in an EntityCollection that match that Query Expression, and do an Update on all records.
You can update multiple records at once by using the ExecuteMultipleRequest message.
CRM doesnt work is SQL way :)
So the update happens based on GUID unlike SQL where you can apply it based on any condition.
The UPDATE message will accept the GUID of the record to be updated along with attributes.
However, you can club all these UPDATE request into a single request using ExecuteMultiple. This however doesnt change the way update happens in CRM - it just reduces the number of calls from client to server.
msdn.microsoft.com/.../microsoft.xrm.sdk.messages.executemultiplerequest.aspx
Thanks,
Prateek
How can I do it like a bulk in sql?
No, you can do update in bulk like in SQL.
The update of record need to go through Update message.
msdn.microsoft.com/.../microsoft.xrm.sdk.iorganizationservice.update.aspx
Thanks,
Prateek
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (