table CustTable update() and additional actions

(0) Share

Report

Posted on by everand

Hi,

While updating some custome field (MyField - a ref AccountNum) in CustTable I need change values in other records same table and same field. It's a correct way - I mean especially declaration variable custTable inside method and using update_recordset?

void update(boolean _updateSmmBusRelTable = true, boolean _updateParty = true)
{
CustTable   this_Orig = this.orig();
CustTable       custTable;
(...)
if (this.MyField != this_Orig.MyField)
{
update_recordSet custTable setting
            MyField = this.MyField
            where custTable.MyField == this.AccountNum
                && custTable.AccountNum != this.AccountNum;
}
}

*This post is locked for comments

All responses (4)

Answers (1)

everand 65 on at

Like (0)

Report

RE: table CustTable update() and additional actions

Even if I need updating other records (not this one, with is currently updated)?

BTW

I created a separate method to achieve my purpose (to use the code in a job also) using doUpdate().
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: table CustTable update() and additional actions

if you want to update the same table fields during update, you can just assign your new value to respected field before super().

Ex:

this.MyField = "MyValue";

Super();

This will take care of the update. No need to call the update method twice.
everand 65 on at

Like (0)

Report

RE: table CustTable update() and additional actions

Yes, it works but I wonder if it's in harmony with let's say best practices
nmaenpaa 101,156 on at

Like (0)

Report

RE: table CustTable update() and additional actions

Did you try it? Did it work?