Re: Absolute amount in query

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.