News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Table write() method n...

Finance | Project Operations, Human Resources, ...

Answered

Table write() method not updating if values not changed?

(0) Share

Report

Report

Posted on by Satch

10

Hi,

I do a select forupdate of a record in a table.

Lets say: table.field1 = A, field2 = B, field 3 = C

Then I do some calculations and the result is A,B and C

When I then call table.write() method, will X++ update the record or is it smart enough to see that the values has not changed?

I ask this because the modified date is not changed on the record. But want to know for sure.

Thanks

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Gunjan Bhattachayya 35,421 on at

Like (1)

Report

RE: Table write() method not updating if values not changed?

Hi Satch,

It will still run the logic in the update method, but if none of the values have changed in the table, the record won't be updated. The fields ModifiedDate, RecVersion etc. will not be updated.

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Quick Links

Leaderboard

#1

André Arnaud de Cal... 294,000 Super User 2025 Season 1

#2

Martin Dráb 232,850 Most Valuable Professional

#3

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans