Calling Update() method in modified() method

(0) Share

Report

Posted on by ThivaKar

931

Hi Experts,

Can we call update() method in the Modified() method?

In my scenario, I am adding a new field in smmBusRelTable and CustTable, the value of this field need to be synced when i enter the values in any one of the above forms (i.e) whenever i enter the value in my field in smmbusreltable form, this value should be upated to the CustTable and vice versa.

Can i use modified() method and their i assign the values like

CustTable.Myfield = smmBusRelTable.MyField;

custTable.update();

Or is their any other way to achieve my requirement. Please advice.

Thanks,

Rusty.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (4)

veera seenivasan 575 on at

Like (0)

Report

Hi Rusty

It is possible to write update operation in modified method

public void modified()

{

super();

if(smmBusRelTable.MyField)

{

ttsBegin;

CustTable.Myfield = smmBusRelTable.MyField;

CustTable.update();

CustTable_ds.refresh();

CustTable_ds.research();

ttsCommit;

}

}

Was this reply helpful? Yes No
Verified answer

DavidGunawan 1,381 on at

Like (0)

Report

Hi Rusty,

To achieve the objective, I suggest you to call doUpdate() in update() method.

Sample

CustTable.update()

{

super();

smmBusRelTable.MyField = CustTable.MyField;

smmBusRelTable.doUpdate();

}

smmBusRelTable.update()

{

super();

CustTable.MyField = smmBusRelTable.MyField

CustTable.doUpdate();

}

Regards

Was this reply helpful? Yes No
Verified answer

Nishant2408 705 on at

Like (1)

Report

Hi Rusty,

It is not a good practice to call an update in modified().

Instead of using modified you can write your code in update() of the table itself by comparing orig() and current value of the field you are updating.

if (this.orig().myfield != this.myfield) //this : specifies smmBusRelTable

{

custable.myfield = this.myfield;

custTable.doupdate(); //if this is just a single filed value which is not affecting any

//other transaction doupdate() can be used in place of update.

}

Do write validation also for the field in validateField() method of the respective table based on the type of the value you are entering.

Was this reply helpful? Yes No
Verified answer

Vilmos Kintera 46,149 on at

Like (0)

Report

I agree with Nishant. You should only change a value pair in another table if validations have passed. For modified, only validateField() is being called. However the stronger logic is usually implemented in validateWrite, which is triggered by update/insert. So you should place your code there, once general validations have passed on saving the record, you could update your pair as well.

To implement it correctly, I would do it in an event handler subscription on the update method.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,878 Most Valuable Professional on at

Like (0)

Report

By the way, I've discussed problems of this design in mu blog post modifiedField() and database consistency. You don't want to update records from modified(), because modified() doesn't mean that the record will ever be saved.

Was this reply helpful? Yes No
ThivaKar 931 on at

Like (0)

Report

Thank you all for your Advice :)

Thank you very much .

Was this reply helpful? Yes No