Re: Query400 question

[rob@xxxxxxxxx]

Excellent idea!

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 




qsrvbas@netscape.net (Tom Liotta)
Sent by: midrange-l-bounces@midrange.com
01/20/2003 02:46 PM
Please respond to Midrange Systems Technical Discussion
 
        To:     midrange-l@midrange.com
        cc: 
        Fax to: 
        Subject:        Re: Query400 question


Further, perhaps the CASE statement could be part of an SQL VIEW, created 
via RUNSQLSTM, OpsNav or QM query, and the view could be read by 
Query/400.

Tom Liotta

midrange-l-request@midrange.com wrote:

>   9. Re: Query400 question
>
>Not in Query/400, as far as I know. However, it is possible in SQL with 
the 
>CASE statement
>
>CASE when xpto='EXW'
>                 then var1=value*0,3
>             else
>                  var1=value*0,4
>END CASE
>
>This can be placed directly into a SELECT statement.
>
>At 03:30 PM 1/20/03 +0000, you wrote:
>>Hi,
>>
>>It is possible to define conditions to use on variables defined in a 
query
>>?
>>
>>IF  xpto='EXW'
>>var1 = value*0,3
>>else
>>var1 = value*0,4
>>
>>var1 is a variable define on the query (definition of a result field)

-- 
-- 
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788 x313
Fax    253-872-7904
http://www.powertechgroup.com


__________________________________________________________________
The NEW Netscape 7.0 browser is now available. Upgrade now! 
http://channels.netscape.com/ns/browsers/download.jsp 

Get your own FREE, personal Netscape Mail account today at 
http://webmail.netscape.com/
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.