General information
Category:
Coding, syntax & commands
1. Why are you storing numbers as characters?
2. If you want to know if FPW will crash on a zero value, why not put in a zero value and see what happens instead of asking here what will happen?
>I have decided to copy the offset values to another table. At that point, it becomes whole numbers again instead of "0000000000001.00" (yet, the file is character type). As I also need to reverse the amount of offset records, this is the program I came up with, yet, it is not working. What am I doing wrong here? Also, will this crash if an "0.00" appears?
>
>Sample:
>5.50 changes to "-000000000005.50"
>-24.00 changes to "0000000000024.00"
>...
>
>IF VAL(nbillamt) < 0
> TRANSFORM(ABS(VAL(nbillamt)),"@LZ 9999999999999.99")
>ELSE
> TRANSFORM(VAL(nbillamt),"@LZ 9999999999999.99")
> REPLACE nbillamt WITH "-" + SUBSTR(nbillamt,2)
>ENDIF
>
>
>Chuck
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only