topic Re: string to int4!! in Application Development and Automation Discussions

string to int4!!

Former Member — Wed, 30 May 2007 06:43:26 GMT

Hi,

I need to move a string variable to int4(10) variable , but the moment i try to move , it's throwing the dump saying conversion not allowed...am trying to move 12:00 to int4 field....

whats the way out?

Regards

Gunjan

Re: string to int4!!

Former Member — Wed, 30 May 2007 06:48:53 GMT

Hi Gunjan,

U cant move :,space or any other special character into Int type variable so try to move 1200 into int4 type variable.

it will work.

data: a type int4,

ch(10) type c.

ch = '1200'.

a = ch.

it works.

Regards,

Ravi G

Re: string to int4!!

athavanraja — Wed, 30 May 2007 06:50:50 GMT

data: abc type string ,

def type int4 .

abc = '12:00' .

shift abc right deleting trailing '0' .

shift abc right deleting trailing ':' .

condense abc no-gaps .

def = abc .

Re: string to int4!!

Former Member — Wed, 30 May 2007 06:52:21 GMT

HI,

use type N instead of I.

data:char(5) value '12:00',num(5) type n.

num = char.

write:num.

rgds,

bharat.