Microsoft Dynamics NAV (Archived)

Validation Not Working

(0) Share

Report

Posted on by jsshivalik

3,099

I have below code but it is not working. It is written in Sub Form

Account No - OnValidate()
IF "Account No" = '' THEN
ERROR(Txt0003);

On Push in Main Form below is the code . CNLine1,CNLine refers to sub form SourceTable

CNLine1.VALIDATE("Account No", CNLine."Account No");

Thanks

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (2)

Suggested answer

CDsilva 4,188 on at

Like (0)

Report

Use session debugging, looks like Account No is fetched as blank.

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

What do you mean by "not working"? It throws an error or it doesn't trow the validation?

If the error returned is the message in Txt0003 then you're passing a blank value (this is what your code is doing).

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report

Hi

It does not throw any error

Thanks

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report

Hi

When Debug it shows

CDNLine1.VALIDATE("Account No", CDNLine."Account No");

= error "Validate("Account No " , CDNLine was not found);

Thanks

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

If it doesn not throw any error is because you're passing a non empty value.

You have written:

CNLine1.VALIDATE("Account No", CNLine."Account No");

it seems that CNLine."Account No" is not empty (in the OnValidate trigger you throw an error ONLY if "Account No." is empty).

Was this reply helpful? Yes No
Suggested answer

CDsilva 4,188 on at

Like (0)

Report

Hi,

Check the property of account no for table relation etc

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report

Hi

In Table it is undefined

Validate Table Relation = Yes

Thanks

Was this reply helpful? Yes No
Suggested answer

4BzSoftware 6,073 on at

Like (0)

Report

Hi jsshivalik,

It seems that you want to make "Account No" should not be left blank.

You can use TESTFIELD("Account No") in OnInsert() trigger of the table.

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report

Hi

Below is the code . CDNLine,CDNLine1 refers to same table.

CDNLine.SETRANGE("Location","No.");

CDNLine.SETFILTER("DAmount",'>%1',0);

IF CDNLine.FINDFIRST THEN BEGIN

REPEAT

EntryNo := EntryNo + 1;

CDNLine1.VALIDATE("Location", "No.");

CDNLine1.VALIDATE("Entry No", EntryNo);

CDNLine1.VALIDATE("Posted Date", CDNLine."DDate");

CDNLine1.VALIDATE("Posted Amount", CDNLine."DAmount");

CDNLine1.VALIDATE("Account No", CDNLine."Account No");

CDNLine1.INSERT;

UNTIL CDNLine.NEXT = 0;

END;

Thanks

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report

Hi Chris

When i write below code then it works but i want if error on Testfield then i want to display my own Error message

CDNLine.TESTFIELD("AccountNo");

CDNLine1.VALIDATE("AccountNo", CDNLine."AccountNo");

Thanks

Was this reply helpful? Yes No