topic Re: decimal data type in Application Development and Automation Discussions

decimal data type

Former Member — Fri, 10 Mar 2006 18:36:59 GMT

Hi,

I know this is a very silly thing to ask.

But i got a doubt regarding the data types.

look at this:

tables: zap. " this is a custom table

in this custom table "zap" the field "price" is defined like this:

price| zap_price| dec | 11 | 6

now in the program there is a field declared like this:

data: zap like zap-price.

now my doubt is:

for the field zap-price is the value can be like this?

a) 46578.654876

b) 4687.645478

which one is correct.

Please let me know.

thnx for the help.,

Former Member — Fri, 10 Mar 2006 18:42:15 GMT

HI Lope,

Both the values are valid. It can accept both the values.

The problem arises when the no of digits in decimal place exceeds 6. That too they wil be rounded off. you can try it writing a simple program.

Regards,

Varun.

Former Member — Fri, 10 Mar 2006 18:42:39 GMT

Total length should be 12 characters - one character for decimal point, 6 places after decimal point and 5 before decimal point.

So both options indicate correct value.

Message was edited by: Ashish Gundawar

Former Member — Fri, 10 Mar 2006 18:46:45 GMT

Hi,

You a) point is right & so is point b).

Your definition means..

the total length of the field is 11,out of which a max of 6 places for decimals & ofcourse 1 will be assigned to the sign(- or +).

Message was edited by: Phani Kiran Nudurupati

Former Member — Fri, 10 Mar 2006 18:54:12 GMT

thnx everybody