Is this statement possible? I just can't get it to work right?

WHERE Channel CONTAINS 'TEAM' OR (GroupName CONTAINS 'Bus' AND Channel CONTAINS 'BUS BKG');  

Thanks for any help possible

JOE

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

Did you try splitting it into two where statments?

Seems to be OK for FOCUS databases:

TABLE FILE CAR
SUM
SALES
BY COUNTRY
BY MODEL

WHERE MODEL CONTAINS 'AUTO' OR (COUNTRY CONTAINS 'AN' AND MODEL CONTAINS 'OR AU'); 
END

What DBMS are you reading? Did you trace the SQL that is generated? Coult the "CONTAINS 'BUS BKG'" be the issue?

Thanks,

I keep getting this error message:

 0 ERROR AT OR NEAR LINE     21  IN PROCEDURE SQLOUT  FOCEXEC *
 (FOC262) UNBALANCED PARENTHESES
 (FOC009) INCOMPLETE REQUEST STATEMENT
 BYPASSING TO END OF COMMAND
 0 ERROR AT OR NEAR LINE     43  IN PROCEDURE EX4_BAK1FOCEXEC *
 (FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: HLDSOURCE
 BYPASSING TO END OF COMMAND
 0 ERROR AT OR NEAR LINE     66  IN PROCEDURE EX4_BAK1FOCEXEC *
 (FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: HLDSOURCE
 BYPASSING TO END OF COMMAND
 0 ERROR AT OR NEAR LINE     91  IN PROCEDURE EX4_BAK1FOCEXEC *
 (FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: HLDSOURCE
 BYPASSING TO END OF COMMAND
 0 ERROR AT OR NEAR LINE    111  IN PROCEDURE EX4_BAK1FOCEXEC *
 (FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: HLDSOURCE
 BYPASSING TO END OF COMMAND
 0 ERROR AT OR NEAR LINE    134  IN PROCEDURE EX4_BAK1FOCEXEC *
 (FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: HLDSOURCE
 BYPASSING TO END OF COMMAND
 0 ERROR AT OR NEAR LINE    157  IN PROCEDURE EX4_BAK1FOCEXEC *
 (FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: HLDSOURCE
 BYPASSING TO END OF COMMAND
 0 ERROR AT OR NEAR LINE    180  IN PROCEDURE EX4_BAK1FOCEXEC *
 (FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: HLDTOTAL
 0 ERROR AT OR NEAR LINE    184  IN PROCEDURE EX4_BAK1FOCEXEC *
 (FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: HLDTOTAL
 BYPASSING TO END OF COMMAND


 

Here is my code:

 TABLE FILE SQLOUT

SUM
     Units
     UnitsPace
     UnitsMTDGoal
     UnitsGoal
     RevCred
     RevCredPace
     RevCredMTDGoal
     RevCredGoal
     OpenBal
     OpenBalPace
     OpenBalMTDGoal
     OpenBalGoal
BY DivisionName
BY GroupName
BY Channel
BY CoreFlag
WHERE DivisionName EQ '&DivisionName';
WHERE GroupName EQ '&GroupName';
-*WHERE ProductGroup NE 'CONSUMER CROSS SELL';
-*WHERE ProductGroup NE 'BUSINESS CROSS SELL';
-*WHERE ( Channel CONTAINS 'TEAM' ) OR ( GroupName CONTAINS 'Bus' ) AND ( Channel CONTAINS 'BUS BKG' ));
WHERE Channel CONTAINS 'TEAM' OR (GroupName CONTAINS 'Bus Bank Sales' AND Channel CONTAINS 'BUS BKG'); 

-*WHERE Channel CONTAINS 'TEAM';

ON TABLE HOLD AS HLDSOURCE FORMAT ALPHA

END
-RUN 

I don't suppose it's complaining about that commented line with the unbalanced parenthesis?

Does the statement work if you add more parenthesis?

WHERE (Channel CONTAINS 'TEAM') OR ((GroupName CONTAINS 'Bus Bank Sales') AND (Channel CONTAINS 'BUS BKG'));

Are your parenthesis actual ASCII parenthesis, or is one of them a different character that looks like a parenthesis?

Do your variables &GroupName or &DivisionName perhaps contain a single quote? I suspect that &GroupName might contain something like:

-SET &GroupName = Some value'(;

That would break this table request.

What also looks peculiar is that your TABLE statement seems to have leading space. Perhaps that's just a copy/paste error in this posting, but if not, WF might be skipping the statement and interpret things a little different from what you expect.

Move your where clauses into the SQL as it could lead to less records being returned and therefore "better" in the long term.

T

quote:

0 ERROR AT OR NEAR LINE 21 IN PROCEDURE SQLOUT FOCEXEC *
(FOC262) UNBALANCED PARENTHESES

quote:

-*WHERE ( Channel CONTAINS 'TEAM' ) OR ( GroupName CONTAINS 'Bus' ) AND ( Channel CONTAINS 'BUS BKG' ));

Are you sure it's commented out when you get the error message?

Thanks for all your replies. I figured it out..I worked it through the GUI Expression grid which excatually worked to what I wanted:

 WHERE ( Channel CONTAINS 'TEAM' ) OR ( GroupName CONTAINS 'Bus Bank' ) AND ( Channel CONTAINS 'BKG' ) OR ( GroupName CONTAINS 'Bus Bank' ) AND ( Channel CONTAINS 'CENT' );