topic Re: Regarding data declaration in Application Development and Automation Discussions

Regarding data declaration

Former Member — Thu, 21 Sep 2006 13:44:33 GMT

I am writing a report based on the number of customers.

For ex: if the number of customers are greater than 50, peform this, if the number of customers are greater than 100, perform that etc.

My question is - Should I declare 'number of customers' as integer or numeric ? What difference does it make?

Thanks in advance for your input,

Krishen

RichHeilman — Thu, 21 Sep 2006 13:47:04 GMT

No difference really since you are not storing the value in a table. Just use integar.

The value is the same, but with a numeric, it is stored with leading zeros, with integar, it is just the value.

Regards,

Rich Heilman

Former Member — Thu, 21 Sep 2006 13:48:47 GMT

Thanks Rich!

If I store the value in a table, should I use numeric ? If so, why?

Regards,

Krishen

Message was edited by: Krishen

anversha_s — Thu, 21 Sep 2006 13:49:16 GMT

hi kishen,

since its customer u declare it integer.

rgds

anver

mark all hlpful answers

Former Member — Thu, 21 Sep 2006 13:49:18 GMT

no difference you can use either of the way ..

RichHeilman — Thu, 21 Sep 2006 13:51:42 GMT

It really depends on how you plan to use this value. If it is strictly a counter type of field, either type would be ok.

Regards,

Rich Heilman

Former Member — Thu, 21 Sep 2006 13:56:27 GMT

hi,

Better you declare it as integer.

If you declare it as numeric, you need to know what will be the upper limit to the no. of customers. Ofcourse, integer also has a limit.

data: v_cnt(4) type n.

it can not hold greater than 9999. So, better declare as integer instead of numeric as you dont know the no of customers.

Regards,

Sailaja.