DECIMAL DOMAIN -- 5 before Point and 15 decimals

[Former Member]

Hi

I need to create a Dom that has 15 decimals and 5 chars

before the point:

ie it should be able to store the value in the format: YYYYY.XXXXXXXXXXXXXXX

I tried creating DOm using DEC data type with decimals 15

but unforunately system is not allowing to create dom with 15 decimals

. So i am stuck in mid.

My customer wants this ! Please advice !

RJ

[Former Member]

Hi,

Just try with type f (floating point no)

[former_member181995]

Data Type        CURR/DEC       "From Domain Defination tab
 No. Characters       20     
 Decimal Places       15     
                             
                             
 Output Length        20     
 Convers. Routine

[Former Member]

I tried this !

Not working !

[former_member181995]

Got any error or what?

[Former Member]

DEcimal places getting changed to 14 automatically !

[Former Member]

hai,

max length is 14 only.

shan.

Edited by: shan palani on Oct 7, 2008 4:52 PM

[Former Member]

shan

try this ur self and tel me !

RJ

[JozsefSzikszai]

well, this is quite normal, there is even a message about this: 14 is the maximum number of decimals you can use for DEC type domains.

I think you have the following options:

-convience your client to use only 14 decimals (I have no idea what difference does it make to use 15 and where you can use that punctuality at all, most currencies have only 2 decimals)

-try data type FLTP, it has 16 decimals (but it is hard coded, that means you cannot change to 15)

[former_member181995]

yes i tried but no success to make it 15

may be we have to live with this(max 14) there would not be an major cause in 14 instead of 15.

[Former Member]

In cas eof FLTP, How many places(digits) can we have before the decimal point ?

My understanding is that we can have 16 decimals places (ie 16 digits after decimal point).

[former_member181995]

In this case The length (including decimal places) is defined as 16 places for this data type.

you need to hardcode one char after the decimal all the time as you need only 15 char after decimal.it is predefined type which must be 16 char only.

[Former Member]

so many digits can we have before decimal point ?