× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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






As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.