Data type to replace int4 type in damain type

[Former Member]

i have a problem here i have to change the data type of the domain from int4 ( which can have -ve values also ) to the type on which i can use offset functionality like in char but i should also be able to use it for basic integer functions .....please suggest me such one data type... points will be rewarded

[Former Member]

i have a problem here i have to change the data type of the domain from int4 ( which can have -ve values also ) to the type on which i can use offset functionality like in char but i should also be able to use it for basic integer functions .....please suggest me such one data type... points will be rewarded

[Former Member]

Hi Abhishek,

I'm afraid there is no such data type available.

Type N comes close to your requirement but cannot hold negative values.

The workaround would be to use local variables whenever you want to do some calculations in the programs in which the field is used.

Regards,

Ravi

[former_member183804]

Hello Abhishek,

you might use the type 'N'. This type is basically a character type which SHOULD contain only numbers. But this restriction is only observed by the standard dialog techniques like dynpros. At programming level you may move any value like 'NONSENS' into a variable of that type. Additinally arithmetic operations are slower compared to integer.

So such a change is a big change in the semantics of your type. To my opininion such a move is only advisable if you do lots of char like operations in only seldom arithmetic calculations.

Kind Regards

Klaus

[Former Member]

Hi

Please check the following threads as this may help to solve your problems.

All The Best

Priyanka

Do Reward Points.