[WEB400] DTW_FORMAT Problem

["Peter Vidal" <Peter_Vidal@xxxxxxxx>]

List, I found out what the problem is.

The field in question was previously edited using DTW_EDIT_CODES and the "J"
code.  The negative symbol passed from the left to the right (mathematically
incorrect for NET.DATA) and the DTW_FORMAT sees this as an invalid number.

Sorry for the inconveniences,
Peter Vidal
Pall Aeropower Corp.
SR Programmer Analyst
WWW.Pall.com

"Have a very Merry Christmas and a more blessed new year 2004 and remember:
JESUS is the reason for the season."
Myself


----- Forwarded by Peter Vidal/Clearwater/Pall on 12/16/2003 03:13 PM -----
                                                                                
                                     
                    Peter Vidal                                                 
                                     
                                         To:     web400@xxxxxxxxxxxx            
                                     
                    12/16/2003           cc:                                    
                                     
                    01:59 PM             Subject:     DTW_FORMAT Problem        
                                     
                                                                                
                                     
                                                                                
                                     



Hi list,

I have a field (nrlhtd) that has a value of  -.01.  I am using this function to
format it:

@DTW_FORMAT(nrlhtd, "", "2", nrlhtd)

It is giving me the error: NET.DATA Error: Function call to DTW_FORMAT failed.
Error Number is 4001.  The book says that "A parameter contains an invalid
number value.".

It have sense if we say that this function will not allow a negative field value
but the manual gives this as an example:
@DTW_FORMAT(" - 12.73", "", "4", result)
Returns: result = "-12.7300"

So I am confused.  What is going on?

TIA,
Peter Vidal
Pall Aeropower Corp.
SR Programmer Analyst
WWW.Pall.com

"Have a very Merry Christmas and a more blessed new year 2004 and remember:
JESUS is the reason for the season."
Myself