Initialize table in X++

(0) Share

Report

Posted on by xain

504

Hi All,

i want to initialize this hcmpersondetails table . because i want to update its fields. without initialzing, values are loading in table but they are not showing up in form.

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (3)

Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

If you initialize values on the buffer bound to the form datasource, then without saving a record on the current buffer, you could try to call refresh, which should render the values onto your form.

kashperuk.blogspot.hu/.../tutorial-reread-refresh-research.html

www.theaxapta.com/.../differences-among-reread-refreshresearch.html

If the record changes are saved to the database, then depending on your situation you could do a reread/research/executeQuery depending on whether you have child datasources, or not.

Was this reply helpful? Yes No
xain 504 on at

Like (0)

Report

Hi

This is my code.

HcmWorker = hcmWorker::findByPersonnelNumber(personalNumber,true);

if(hcmworker::findByPersonnelNumber(personalNumber))

{

if(hcmWorker.Person)

{

dirPartyTable = dirPartyTable::find(dirPerson::find(HcmWorker.Person).PartyNumber);

if(!dirPartyTable)

{

dirPartyTable = DirPartyTable::createNew(DirPartyType::Person,vendorName);

}

else

{

dirPersonName = DirPersonName::find(hcmWorker.Person,true);

dirPersonName.validTimeStateUpdateMode(ValidTimeStateUpdate::Correction);

dirPersonName.FirstName = firstName;

dirPersonName.LastName = lastName;

dirPersonName.write();

}

}

ttsBegin;

dirPerson = dirPerson::find(DirPartyTable.RecId, true);

// dirPerson.MaritalStatus = maritalStatus;

dirPerson.write();

HcmWorker.Person = dirPerson.RecId;

HcmWorker.write();

HcmPersonDetails.initValue();

HcmPersonDetails = HcmPersonDetails::findByPerson(dirPerson.RecId);

//if(!HcmPersonDetails.RecId)

//{

//break;

//}

hcmPersonDetails.selectForUpdate(true);

HcmPersonDetails.validTimeStateUpdateMode(ValidTimeStateUpdate::Correction);

HcmPersonDetails.Person = dirPerson.RecId;

hcmPersonDetails.MaritalStatus = maritalStatus;

hcmPersonDetails.NumberOfDependents= noOfDependent;

hcmPersonDetails.write();

what is wrong in this. can u specify. Thanks

Was this reply helpful? Yes No
Vilmos Kintera 46,149 on at

Like (0)

Report

In what context is the above code being called, in relation to the form where you want to display the values?

Was this reply helpful? Yes No
xain 504 on at

Like (0)

Report

i want to display values in employee master data. employee data is there but i want to update their marital status and numberOfDependent Values

Was this reply helpful? Yes No
Verified answer

Chaitanya Golla 17,225 on at

Like (0)

Report
Hi,

I just fixed your code in a job to update hcmPersonDetails tables.

static void AXC_Party(Args _args) { HcmWorker hcmWorker; dirPartyTable dirPartyTable; dirPersonName dirPersonName; str personalNumber = "123"; str vendorName; str firstName, lastName; dirPerson dirPerson; HcmPersonDetails HcmPersonDetails; HcmPersonMaritalStatus maritalStatus = HcmPersonMaritalStatus::Married; int noOfDependent; hcmworker = hcmWorker::findByPersonnelNumber(personalNumber,true); if(hcmworker.Person) { dirPartyTable = dirPartyTable::find(dirPerson::find(hcmworker.Person).PartyNumber); if(!dirPartyTable) { dirPartyTable = DirPartyTable::createNew(DirPartyType::Person, vendorName); } else { dirPersonName = DirPersonName::find(hcmWorker.Person,true); dirPersonName.validTimeStateUpdateMode(ValidTimeStateUpdate::Correction); dirPersonName.FirstName = firstName; dirPersonName.LastName = lastName; dirPersonName.write(); } } ttsBegin; dirPerson = dirPerson::find(DirPartyTable.RecId, true); dirPerson.MaritalStatus = maritalStatus; dirPerson.write(); ttsCommit; HcmPersonDetails = HcmPersonDetails::findByPerson(dirPerson.RecId); if (HcmPersonDetails.RecId) { ttsBegin; hcmPersonDetails.selectForUpdate(true); HcmPersonDetails.initValue(); HcmPersonDetails.validTimeStateUpdateMode(ValidTimeStateUpdate::Correction); HcmPersonDetails.Person = dirPerson.RecId; hcmPersonDetails.MaritalStatus = maritalStatus; hcmPersonDetails.NumberOfDependents= noOfDependent; hcmPersonDetails.update(); ttsCommit; } }

Was this reply helpful? Yes No
xain 504 on at

Like (0)

Report

Hi

i tried the changes that u have made. but it says cannot update because record never selected. which is true because there is no record in hcmpersondetails table.

so how can i solve that problem. Thanks

Was this reply helpful? Yes No
Verified answer

Chaitanya Golla 17,225 on at

Like (0)

Report
Hi,

I think you haven't used my code completely, as there is an if condition and you will not get this error in first place. I am referring to below code

HcmPersonDetails = HcmPersonDetails::findByPerson(dirPerson.RecId); if (HcmPersonDetails.RecId)

Anyway, I was thinking you are trying to update the values please use below code

ttsBegin; dirPerson = dirPerson::find(DirPartyTable.RecId, true); dirPerson.MaritalStatus = maritalStatus; dirPerson.write(); HcmPersonDetails.initValue(); HcmPersonDetails.validTimeStateUpdateMode(ValidTimeStateUpdate::Correction); HcmPersonDetails.ValidFrom = DateTimeUtil::utcNow(); HcmPersonDetails.ValidTo = DateTimeUtil::maxValue(); HcmPersonDetails.Person = dirPerson.RecId; hcmPersonDetails.MaritalStatus = maritalStatus; hcmPersonDetails.NumberOfDependents= noOfDependent; hcmPersonDetails.write(); ttsCommit;

Was this reply helpful? Yes No
xain 504 on at

Like (0)

Report

Hi Chaitanya Golla,

Thanks a million , u saved my day...

Was this reply helpful? Yes No