[SPAM] - NCONVERT Output - Sender is forged (SPF Fail)

[Pickering, John (NORBORD)]

Try multiplying the result of NCONVERT by a power of 10 to move the decimal
to the right. You can always divide by the same power of 10 later to get he
decimal back in the correct place.

:quiz
> def d-x char*10 = "12.345"
> def d-n num*10 = nconvert(d-x) * 1000
> rep all
> go

  d-x      d-n
12.345 12345


-----Original Message-----
From: John Stires [mailto:pencarver at sbcglobal.net]
Sent: Friday, December 02, 2005 10:08 AM
To: powerh-l at lists.sowder.com
Subject: [SPAM] - NCONVERT Output - Sender is forged (SPF Fail)


One of my coworkers has been rather perplexed with NCONVERT.  He is
attempting to convert a number with a decimal component.  Instead of getting
a numeric with the decimal component still intact, he is getting in integer
number.  He has tried using NUM and FLOAT for the receiving defined field.
Both with the same results.  

The ultimate goal is to produce a value with the decimal component to save
in a file.

It would seem that we are missing something obvious, but what???

We are running on a VAX with VMS 6.2 and PowerHouse version 7.10.E6.

I do not believe the fact that we are using this out of an RDB database
would have any bearing on this.

Any good ideas?

Thanks,
John