Re: Absolute amount in query

[GUY_HENZA@xxxxxxxxxxxxxx]

Na, that don't work so well...

WRKQRY
Define Result Fields
 Field       Expression                         Column Heading        Len
Dec
 ABS         ABS(SEQNO)
 Operator or function name needed before left parenthesis.

Regards,

Guy



                                                                                                                                          
                      "Michael Rosinger"                                                                                                  
                      <mrosinger@xxxxxxxxx        To:       midrange-l@xxxxxxxxxxxx                                                       
                      >                           cc:                                                                                     
                      Sent by:                    Subject:  Re: Absolute amount in query                                                  
                      midrange-l-bounces@m                                                                                                
                      idrange.com                                                                                                         
                                                                                                                                          
                                                                                                                                          
                      12/13/2007 08:57 AM                                                                                                 
                      Please respond to                                                                                                   
                      Midrange Systems                                                                                                    
                      Technical Discussion                                                                                                
                                                                                                                                          
                                                                                                                                          




specify function ABS()..... ABS(:hostvar) or ABS(column)

--
Regards,

Michael Rosinger
Systems Programmer / DBA
Computer Credit, Inc.
640 West Fourth Street
Winston-Salem, NC  27101
336-761-1524
m rosinger at cciws dot com
"Tomasz Skor¿a" <t.skorza@xxxxxxxxxxx> wrote in message
news:mailman.22805.1197539863.4459.midrange-l@xxxxxxxxxxxxxxx
> Hi guys
>
> Is it possible to get new field "absolute amount" in QUERY/400 for any
> other
> numeric fields? (WRKQRY)
>
> I'mean 1000 for field=-1000 and also 1000 for field=1000
>
> Regards
>
> --
> Tomek


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.