<SOLVED> syntax for where statement for Parameter

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4477034326

August 22, 2012, 03:09 PM

<SOLVED> syntax for where statement for Parameter

What is the correct syntax if I need to add a 2nd condition ( T4.T4.XXXX EQ 'X') "AND" to the where statement in Pop4 Parameter:

WHERE (T1.T1.Pop1 EQ 'Y' AND 'Y' EQ '&Pop1_FLAG') OR
(T1.T1.Pop2 EQ 'Y' AND 'Y' EQ '&Pop2_FLAG') OR
(T1.T1.Pop3 EQ 'Y' AND 'Y' EQ '&Pop3_FLAG') OR
(T1.T1.Pop4 EQ 'Y' AND T4.T4.XXXX EQ 'X' T4.T4.XXXX EQ 'X' AND 'Y' EQ '&Pop4_FLAG');

thanks,
DG

This message has been edited. Last edited by: DG,

August 22, 2012, 03:30 PM

susannah

quote:
OR (T1.T1.Pop4 EQ 'Y' AND T4.T4.XXXX EQ 'X' T4.T4.XXXX EQ 'X' AND 'Y' EQ '&Pop4_FLAG');

OR ((T1.T1.Pop4 EQ 'Y' AND T4.T4.XXXX EQ 'X') AND ( T4.T4.XXXX EQ 'X' AND 'Y' EQ '&Pop4_FLAG'));

is that what you want? why not just make a single compound out of the Pop4 EQ 'Y' OR &Pop4_FLAG.QUOTEDSTSRING

August 22, 2012, 08:04 PM

I will test that.

Thanks.

August 23, 2012, 04:27 AM

Wep5622

quote:
Originally posted by DG:
What is the correct syntax if I need to add a 2nd condition ( T4.T4.XXXX EQ 'X') "AND" to the where statement in Pop4 Parameter:

WHERE (T1.T1.Pop1 EQ 'Y' AND 'Y' EQ '&Pop1_FLAG') OR
(T1.T1.Pop2 EQ 'Y' AND 'Y' EQ '&Pop2_FLAG') OR
(T1.T1.Pop3 EQ 'Y' AND 'Y' EQ '&Pop3_FLAG') OR
(T1.T1.Pop4 EQ 'Y' AND T4.T4.XXXX EQ 'X' T4.T4.XXXX EQ 'X' AND 'Y' EQ '&Pop4_FLAG');

thanks,
DG

I think you mean

WHERE (T1.T1.Pop1 EQ 'Y' AND 'Y' EQ '&Pop1_FLAG') OR
      (T1.T1.Pop2 EQ 'Y' AND 'Y' EQ '&Pop2_FLAG') OR
      (T1.T1.Pop3 EQ 'Y' AND 'Y' EQ '&Pop3_FLAG') OR
      (T1.T1.Pop4 EQ 'Y' AND  T4.T4.XXXX EQ 'X' AND 'Y' EQ '&Pop4_FLAG');

You duplicated part of an expression in that last line.

WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :