problem with int4 data type

[Former Member]

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.

[Former Member]

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......

[Former Member]

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.

[Former Member]

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.

[Former Member]

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