about goto

I need to conditionally skip a where condition based on the previous where condition. Here is my code.
BY Customer_Name AS 'Customer/Name'
BY PARTNO
WHERE ( CO EQ '&iComp.EVAL' );
WHERE ( YM GE '&CURP.EVAL' ) AND ( EXTRACTYM GE '&CURPE.EVAL' ) AND ( YM LE '&NEXT5P.EVAL' ) AND ( EXTRACTYM LE '&NEXT5P.EVAL' );
WHERE (PLTCODE EQ '&PLANT');
WHERE (CUST EQ '&CUST') ;
WHERE (PC NE 'N0A10' OR 'N0A20' OR 'A0X01');
&CUSTNAME_IND.EVAL WHERE (CUSTNAME LIKE '&CUSTNAMEL.EVAL') ;
WHERE (PC EQ '&PC') ;
-IF &iComp EQ 'C' GOTO AAA;
WHERE (RBU EQ '&BU')
-AAA
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
I need to skip the check for RBU if the Company is 'C'

Donald,
Instead of:

quote:

-IF &iComp EQ 'C' GOTO AAA;
WHERE (RBU EQ '&BU')
-AAA

use:

  
WHERE (RBU EQ '&BU') OR (CO EQ 'C');

How about this

 WHERE ((CO NE 'C') OR ((CO EQ 'C') AND RBU EQ '&BU')) 

Gene

quote:

&CUSTNAME_IND.EVAL WHERE (CUSTNAME LIKE '&CUSTNAMEL.EVAL') ;

Not sure what that line is doing.

So what error are you getting here.

Also please update your signature in your profile as to what version you are on.