Microsoft Dynamics AX (Archived)

How to create a method to check record repeat and show info

(0) Share

Report

Posted on by ATMA-Jen

319

Hi All,

When user key a record, if itemid is repeat, how to show a message to reminder?

How I create the method in DataSource or Form Design, could used the override method??

thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Verified answer

Chaitanya Golla 17,225 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Do you mean once user creates a record, if so there are many ways to accomplish this.One way is to get count of records in the validatewrite method of the datasource.

Here InventJournalTrans is the form datasource and gets the selected record on grid.

public boolean validateWrite()

{

InventJournalTrans trans;

ret = super();

select count(RecId) from trans

where trans.ItemId == InventJournalTrans.ItemId

&& trans.JournalId == InventJournalTrans.JournalId;

if (trans.RecId > 1)

{

info("ItemId Repeat");

}

}

return ret;

}

If you want to stop record from creation, simply you can create an unique index on inventjournalTrans based on journaltype.

Hope this helps you.

Thanks,

Chaitanya Golla

Was this reply helpful? Yes No
ATMA-Jen 319 on at

Like (0)

Report
Copy link

Link copied!

Hello Golla,

Thanks for your help in advance.

I Try your code and run,

but no show info message?

please tell me why?

code:

Run:

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please don't comment any base code, rather add your code to the method.

Your code in validate write should look like the following

public boolean validateWrite()

{

InventJournalTrans trans;

boolean ret;

inventJournalTrans.InventDimId = InventDim::findOrCreate(inventDim).InventDimId;

ret = super();

ret = journalFormTrans.datasourceValidateWritePost(ret);

select count(RecId) from trans

where trans.ItemId == InventJournalTrans.ItemId

&& trans.JournalId == InventJournalTrans.JournalId;

if (trans.RecId > 1)

{

info("Repeat");

}

return ret;

}

Was this reply helpful? Yes No
ATMA-Jen 319 on at

Like (0)

Report
Copy link

Link copied!

Hello Golla,

Got it & thanks a lot....

I try again, but really want to know why not work??

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report
Copy link

Link copied!

Hi,

In the screenshot I couldn't find the base code. Please retain the base code and add this new code to it or else just copy paste the validatewrite method I provided.

Thanks,

Chaitanya Golla

Was this reply helpful? Yes No
ATMA-Jen 319 on at

Like (0)

Report
Copy link

Link copied!

Try again: (Poor English)

Still no work:

Was this reply helpful? Yes No
ATMA-Jen 319 on at

Like (0)

Report
Copy link

Link copied!

Hello Chaitanya Golla,

Thanks for your help.

I debug:

I New 2 Itemid , and click the validate button, then it's OK,

I check the code and trans.RecId =1

I don't know why??

Was this reply helpful? Yes No
ATMA-Jen 319 on at

Like (0)

Report
Copy link

Link copied!

Hello,

I Debug:

When I new one row data, trans.RecID=0,

when I new two same rows data, trans.RecID=1,

I don't Know Why??

So, I edit the code is

if (trans.RecId > 0)
{
info('Repeat');
}

I thins It's OK.

Thank you very much for you help kindly.

Was this reply helpful? Yes No