Form Field : Integer type field, need to show zero but keep missing.

(0) Share

Report

Posted on by Community Member

Hey expert,

I have this integer fields.

Every time, i add 0050 and 0080, it keeps showing 50 and 80, i know it's because it's integer data type. But i need this to show zero in front of the number inputted. I can't change it to string. Any idea how to do it?

*This post is locked for comments

I have the same question (0)

All responses (25)

Answers (1)

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

one most communly used way is to use EditDisplay method

Was this reply helpful? Yes No
Suggested answer

Hariharans87 3 on at

Like (0)

Report

If It is only for display purpose then, you can use display method else you can use edit method.

For display method e.g.

display str FormattedTestNo()

{

return strRFix(int2str(Form_DS.TestNo), 4, '0');

}

Result: if the value is 50, you will get 0050

Was this reply helpful? Yes No
Hariharans87 3 on at

Like (0)

Report

Sorry, I did a mistake in the example part.

display str FormattedTestNo(Hari_Test Form_DS)

{

return strRFix(int2str(Form_DS.TestNo), 4, '0');

}

We should pass the form datasource if we use display method in the form.

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

"Every time, i add 0050 and 0080" depicts that he/she want to use it for data entry, so display method will be worthless

Was this reply helpful? Yes No
Dauvis 170 on at

Like (0)

Report

An edit method is the probably the best way to do this. The drawback on that will be that the field will not be available for filtering.

Was this reply helpful? Yes No
Hariharans87 3 on at

Like (0)

Report

Yes. You can't filter and sort the edit and display method's data. If you want filter method, you should go for string field.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Hari, thanks for your code example.

From your's example here's my code :

display str FormattedNoFrom(DDSetupDDDetail _DDSetupDDDetail)

{

return strRFix(int2str(_DDSetupDDDetail.SetupTaxNoFrom), 4, '0');

}

I create this method on form/datasource/tablename's method.

Now i should assign it to dataMethod of control property right? But when i do so, the field suddenly cannot be edited and always showing this number 3145776

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Sohaib, can you give me example code like Hari did earlier, about edit method?

I'm planning to create it in form/Datasource's method. Thanks.

I need example code of editmethod.

Was this reply helpful? Yes No
Hariharans87 3 on at

Like (0)

Report
Please use the below code for edit method and make sure your field maximum length is 4. If it is not 4 then, please mention the maximum length number strRFix function.

edit str editFormattedNoFrom(boolean set, DDSetupDDDetail _DDSetupDDDetail, str enteredNo) { int taxNo; if(Set) { taxNo = str2int(enteredNo); _DDSetupDDDetail.SetupTaxNoFrom = taxNo; } else { taxNo = _DDSetupDDDetail.SetupTaxNoFrom; } return strRFix(int2str(taxNo), 4, '0'); }

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi, i keep getting error on this, operand not compatible

edit SetupTaxNoFrom formattedNoFrom( ->my EDT with type int not string

boolean _set,

SetupVATDetail _SetupVATDetail, ->my datasourcename in form

SetupTaxNoFrom _SetupTaxNoFrom) ->my EDT again right

{

return strRFix(int2str(_SetupVATDetail.SetupTaxNoFrom), 4, '0'); ->return string??

}

Was this reply helpful? Yes No