I have a display item that must sho

[prosuc]

I have a display item that must show a numeric value edited without decimals if it haven't, but Form shows the decimals anyway, What is the Format mask that I have to use?:


data base value FORMAT_MASK Form 6i Edit I want
----------------- --------------------- ------------- ---------
.5 999G999 0.500 0.5
12 999G999 12.000 12
.05 999G999 0.050 0.05
1.2 999G999 1.200 1.2

Forms [32 Bit] Version 6.0.8.13.0 (Production)

thanks,
Pablo

 

[lewisp]

If you provide no format model at all with a number datatype, you will get

.5
12
.05
1.2

If you provide a format model of FM9990.999

You will get

0.5
12.
0.05
1.2

Your third option is to have some post query processing to use the FM9990.99 format model in a To_Char conversion then remove any trailing decimal points.

 

[prosuc]

o.k.
Thanks lewisp.