ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

How can we differentiate Positive and Negative Values

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How can we differentiate Positive and Negative Values

    Hi,

    In my database file, i am having a field of zoned numeric (8,2) variable.
    It can have both the positive as well as negative values.

    When i am using RUNQRY or STRSQL.
    I cann't see the difference between the Positive and Negative values as no Sign is displayed along with value until i use the conditions like value >0 or <0.

    Is there any way to show the differentiate between the Positive and Negative values.

    Thanks in Advance,
    Surya

  • #2
    Re: How can we differentiate Positive and Negative Values

    Actually what happened here is the physical file is having edit code 3, which is suppressing the -ve sign.

    But, how can i show the -ve sign.
    Last edited by Surya; January 23, 2007, 03:50 AM.

    Comment


    • #3
      Re: How can we differentiate Positive and Negative Values

      Hi, within query, place a 1 on the "Specify report column formatting "
      Then on the field you want press F16 to get this;

      PHP Code:
                                Define Numeric Field Editing        
                                                                    
       Field 
      . . . . . . . . :   E3SEND                             
       Text  
      . . . . . . . . :   Sent Count                         
       Heading 1 
      . . . . . . :   Sent                               
       Heading 2 
      . . . . . . :   Count                              
       Heading 3 
      . . . . . . :                                      
       
      Length  . . . . . . . :   10                                 
       Decimal 
      . . . . . . . :   0                                  
       Sample  
      . . . . . . . :   9,999,999,999                      
                                                                    
                                                                    
                                                                    
                                                                    
       Type choice
      press Enter.                                    
                                                                    
         
      Edit option . . . . .   1     1=Numeric editing choices    
                                       2
      =Date or time editing choice
                                       3
      =Edit code                  
                                       4
      =Edit word 
      Here you can change the formating to what you wish.
      Hunting down the future ms. Ex DeadManWalks. *certain restrictions apply

      Comment

      Working...
      X