Validation on the fields

(0) Share

Report

Posted on by D365 beginner

634

Hi Guys,

I have a form & table called CommissionTrans where I have the dropdown field settlementId. I need to select the SettlementId for each transactions manually on this form . I have to add a validation that I should be able to select one settlementId for one transaction only. If I select the same ID for next transaction it should show an error that its already used for another transaction. how can I do it ? which validation method to be added and how the code should be.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

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

Like (0)

Report

Which method you should use depends on when you want to run the validation. For example, if you want to do it on save, override validateWrite() method on the table.

Simply a run a query to check whether there already is another transaction with the same settlement ID and return false if it is. You'll likely want to create an index on SettlementId, to make this query efficient.

Was this reply helpful? Yes No
D365 beginner 634 on at

Like (0)

Report

Hi Martin,

Thanks for the reply.

I Just made some changes in the requirement as I created a new child form (CommissionTransSettlement) and I would like to select the settlement Id from the child form. In this case I am trying to modify the clicked method already there on the button from where I can select the SettlementId. how can I call the function validatefield() created on the table commissiontrans on this form.

void clicked()

{

commissionTrans CommissionTrans;

super();

ttsbegin;

while select forUpdate CommissionTransSettlement

{

CommissionTransSettlement.Delete();

}

ttscommit;

ttsbegin;

select forUpdate CommissionTrans

where CommissionTrans.InvoiceId == CommissionTransSettlement.InvoiceId

&& CommissionTrans.EmplId == CommissionTransSettlement.EmplId ;

CommissionTrans.SettlementId = CommissionTransSettlement.SettlementId;

CommissionTrans.update();

ttscommit;

element.close();

}

Was this reply helpful? Yes No
Verified answer

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

Like (0)

Report

Don't use a regular button with clicked(). Use a command button with Command = OK and override closeOk(). The validation can be done in canClose(). Nevertheless removing all the code and using a lookup form would likely be a better approach. Then you would use validateWrite() and or validateField() as discussed before.

I don't know what's the purpose the while select + delete; it looks suspicious. And the fact there is no condition must be a bug.

If you really need some deletion, remember never put any code like this on client. It meaninglessly fetches all CommissionTransSettlement records from database to client just to send delete commands (one by one) back to database. It's a performance killer. It's made even worse by the long-living transaction created on client. *If* you need this logic, put it in a server-side method and replace the while select with delete_from.

Was this reply helpful? Yes No

Community site session details

Validation on the fields

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Validation on the fields

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates