Re: Absolute amount in query

[Nick_Radich@xxxxxxxxxxxxxx]

I get the same thing.

But, I am only on V4R5.

Does this work on a newer (post dinosaur era) release?



Thanx,

Nick



Nick Radich
Sr. Programmer/Analyst
EPC Molding, Inc.
Direct  (320) 679-6683
Toll free  (800) 388-2155  ext. 6683
Fax  (320) 679-4516
nick_radich@xxxxxxxxxxxxxx



GUY_HENZA@xxxxxxxxxxxxxx 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
12/13/2007 08:06 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc

Subject
Re: Absolute amount in query







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.