topic Re: problem with int4 data type in Application Development and Automation Discussions

problem with int4 data type

Former Member — Mon, 12 Mar 2007 14:39:04 GMT

hi,

while i am creating table i used int4 data type ,but after i enter the values it is taking the decimal places,so why it is comming decimal palces i dont know,can any body have the idea pls let me know.

Re: problem with int4 data type

Former Member — Mon, 12 Mar 2007 14:45:24 GMT

hi rammohan.....

i tried to do the same...

but the record is not inserted inti the database if u give a decimal point......

Just check it once......

Reward points if useful......

Suresh......

Re: problem with int4 data type

Former Member — Tue, 13 Mar 2007 04:25:05 GMT

the int4 data type is mapped in the following way with the work bench is

it takes 4 hexa decimal bytes to store that in programming environment.

INT4: 4-byte integer between -2147483647 bis 2147483647. The length is set to 10 places for this data type.

Re: problem with int4 data type

Former Member — Tue, 13 Mar 2007 05:26:17 GMT

Hi Rammohan,

<b>1st possiblity:</b>

May be there exists a CONVERSION ROUTINE( unfortunately ), check it once...............

<b>2nd possiblity:</b>

GOTO system ---> user profile -

> own data

In that,Click Default option.OK.Here u can see some

decimal formatting options.May be these are affecting...

Reward,if helpful.

Regards,

V.Raghavender.

Re: problem with int4 data type

Former Member — Thu, 15 Mar 2007 07:28:25 GMT

Hi,

You check your data type.May be your data type u mentationing Decimal place : 2

so it displaying decimal value. make Decimal place is 0.

Thanks...

Sasmita