In X++ onValidatingField

(0) Share

Report

Posted on by Riyas ahamed F

1,215

Hi guys,

/// 
    ///
    /// 
    /// 
    /// 
    [DataEventHandler(tableStr(HcmJob), DataEventType::ValidatingField)]
    public static void HcmJob_onValidatingField(Common sender, DataEventArgs e)
    {
        HcmJob  thisRecord = sender as HcmJob ;
        ValidateFieldEventArgs event = e as ValidateFieldEventArgs;
        FieldId fieldId = event.parmFieldId();
        boolean ok = event.parmValidateResult();
        switch(fieldId )
        {
       
            case fieldNum(HcmJob, PhoneNumber):

                if(ok && strLen(int2Str(thisRecord.PhoneNumber)) !=10)
                {
                    ok = checkFailed('Phone number should be in 10 digit only!');
                }

                break;
            default:
       }

        event.parmValidateResult(Ok);

    }

sorry for the stupid question.

My Requirement in phone number 10 digit only so that i wrote OnvalidatingField Events in Hcmjob

in my phone number integer filed and i don't want to add String.

1. if i gives 10 digit number i am getting error

so i cannot give it to 10 digit number how did i mistake and what should i do?

Thanks.

I have the same question (0)

All responses (6)

Answers (2)

Blue Wang on at

Like (0)

Report

Hi Riyas,

What is your field type? int? Have you tried Int64.

Besides that, you can use string control,then try to use regular expression.

Was this reply helpful? Yes No
Maverick 182 on at

Like (0)

Report

Hi Riyaz,

Can you try int642str instead of int2str

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,162 Moderator on at

Like (1)

Report

Phone numbers are not integers, they should be stored as strings. Remember that phone number can:

- start with zero

- have special characters such as +

- often people prefer to put spaces in between the number to make it more easily readable

And, as you noticed with your error message, integer data type can't store numbers that are 10 numbers long. Int64 could do that but as mentioned above, it's still not the data type that you should use.

So, integer is not the correct data type to use. And if you look at Phone data type in AOT, you notice it's a string. Phone numbers are stored in LogisticsElectronicAddress.Locator which is also a string.

Was this reply helpful? Yes No
Riyas ahamed F 1,215 on at

Like (0)

Report

Thanks for your replay blue wang,

i tried in Int64 but same error came what should i do.

Was this reply helpful? Yes No
Verified answer

Blue Wang on at

Like (0)

Report

Hi Riyas,

So, as mentioned, you have to use string ,write code to verify the value.

community.dynamics.com/.../validation-for-numeric-values-in-ax

Was this reply helpful? Yes No
Riyas ahamed F 1,215 on at

Like (0)

Report

Thanks for your valuable answer Nikolaos Mäenpää.

Was this reply helpful? Yes No