topic Re: covert to number:runtime error in Application Development and Automation Discussions

covert to number:runtime error

Former Member — Fri, 02 May 2008 11:27:46 GMT

Hi friends,

i am getting runtime erro CONVERT TO NUMBER error as: Unable to interpret "5,794.58 " as a number

orginal value 5,794.58 in v_cost char field..

now i want tomove it to currency field i_cost-insu.

error occuring while moving i_cost-insu = v_cost.

i know that i can do as follow to solve this , but i want to display to user as 5,794.58.

replace all occurrences of ',' in v_cost with space .

condense v_cost.

i_cost-insu = v_cost.

but i want to displlay user as 5,794.58 how can i solve this

please help me

thanks

Ramesh

Former Member — Fri, 02 May 2008 11:34:16 GMT

hi ,

in currency field you cannot assign number with ','.

it will give error.

if you want to display it as 5,794.58 .

than display with charecter field,

y u want to display currency field? display values in char field

Former Member — Fri, 02 May 2008 11:39:02 GMT

Hi,

You will have to use statement REPLACE.

REPLACE ALL OCCURANCES OF ',' IN v_cost WITH ' '.

CONDENSE v_cost NO GAPS.

use these statements, this will solve your problem.

Regards,

Bharat.

Former Member — Fri, 02 May 2008 11:40:20 GMT

Hi,

Could you try the addition currency with write statement to display the value.

Regards,

Vijayalakshmi

asik_shameem — Fri, 02 May 2008 11:49:44 GMT

Do in this way.

TRANSLATE v_cost USING ',.'. 
i_cost-insu = v_cost