topic Re: Data Type Conversion in Application Development and Automation Discussions

Data Type Conversion

Former Member — Tue, 19 Jan 2010 17:25:19 GMT

I have a string as follows:

0000060880000

I need to assign it to a field in a database record with

the following type CURR Length 11 Decimals 2

When I move it into this field it is recorded as

60,880,000.00

It should be recorded as 60.88

How would I do that?

Re: Data Type Conversion

Former Member — Tue, 19 Jan 2010 17:28:00 GMT

The only way would be to divide the number with 1000000

field = 0000060880000 / 1000000.

Re: Data Type Conversion

former_member156446 — Tue, 19 Jan 2010 17:28:27 GMT

divide by 1000000

Re: Data Type Conversion

prasenjit_sharma — Tue, 19 Jan 2010 17:53:18 GMT

Hi,

I did not understand why you want to store 0000060880000 as 60.88. What is your logic? Would you always divide the no by

1000000 or this is a constant no?

Well, if 0000060880000 is character type then you might have to move it to a numeric variable first then divide and then write to CURR and I suppose you'd need a UOM for the currency. Do you have that logic ready?

Regards

Prasenjit