News and Announcements icon

Dynamics 365 CommunityForums Finance forum Can we use Update_Reco...

Finance forum

Answered

Can we use Update_Recordset for a single record or just less number of records updating?

(0) Share

Report

Report

Posted on by JohnBright

87

Hi experts,

I am just wondering whether I could use update_recordset to update a value for a single record. Microsoft has used update_recordset where there are lot of records needs to be updated. But is there any downsides we will be having if we use the same for a single record updation? Is there any reason for us to user the update method in this scenario?

Also, I wanna understand whether update_Recordset will process anything different when compared to normal update method since it as well hits the table's update method unless the table methods is been forced to not to be called.

Thanks in advance.

Categories:

Development / Customization / SDK

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Martin Dráb 228,501 Most Valuable Professional on at

Like (0)

Report

Can we use Update_Recordset for a single record or just less number of records updating?

When you run update_recordset, you update all records meeting a condition. There may be multiple records, but it may be just a single one or none at all. Therefore yes, it can be used for a single record.

If update() method is overriden, it'll be called by update_recordset (unless suppressed), as you correctly mentioned. But that means that you're losing performance benefits of update_recorset, because it needs to fetch records from DB and call the method on each of them, instead of simply sending an UPDATE command to database.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2

Martin Dráb 228,501 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans