I wrote an initial WebFocus report in 7.6.6 and it ran fine with the Where statement...

WHERE ( COMPANY EQ '&COMPANY.(FIND COMPANY,COMPANY IN IRSUM).Company.' ) AND ( WAREHOUSE EQ '&WAREHOUSE.(FIND WAREHOUSE IN IRSUM).Warehouse.' );

...but after I save and close it and then reopen it, it won't run (I get an error) and the Where statement has been truncated to 80 characters...

WHERE ( COMPANY EQ '&COMPANY.(FIND COMPANY,COMPANY IN IRSUM).Company.' ) AND ( W

I tried searching on "where statement trucated" but found nothing. Anyone know what I'm doing wrong?

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

What error do you get ?

Split the code into two lines

WHERE ( COMPANY EQ '&COMPANY.(FIND COMPANY IN IRSUM).Company.' ) ;
WHERE ( WAREHOUSE EQ '&WAREHOUSE.(FIND WAREHOUSE IN IRSUM).Warehouse.' );

and see what happens.

RSquared,
Thanks for your reply. The error was unimportant and not realted since it was a result of the truncatin of the Where statment which made the next statement invalid (ON TABLE SET...).

FrankDutch,
Thanks for your reply. That worked (separate Where statements). However, I abbreviated my initial Where statement example for this post. The actual original Where statement is...

WHERE ( COMPANY EQ '&COMPANY.(FIND COMPANY,COMPANY IN IRSUM).Company.' ) AND ( WAREHOUSE EQ '&WAREHOUSE.(FIND WAREHOUSE IN IRSUM).Warehouse.' ) AND ( LOGO EQ '&LOGO.(FIND LOGO IN IRUPC).Logo.' ) AND ( DATE GE '&FROMDATE.From Date.' ) AND ( DATE LE '&THRUDATE.Thru Date.' ) AND (( BOSBEGPRS NE 0 ) OR ( BOSRCPPRS NE 0 ) OR ( BOSHPPRS NE 0 ) OR ( BOSADJPRS NE 0 ) OR ( BOSRTNPRS NE 0 ) OR ( BOSENDPRS NE 0 ));

...so now my dilemma is how to get that last "AND" statement in there since there is no way it will fit in 80 characters and if I split it on two lines it won't work logically (since I would assume the multiple Where statements are "ANDed" together).

This should fit on one line I think.

WHERE (( BOSBEGPRS NE 0 ) OR ( BOSRCPPRS NE 0 ) OR ( BOSHPPRS NE 0 ) OR ( BOSADJPRS NE 0 ) OR ( BOSRTNPRS NE 0 ) OR ( BOSENDPRS NE 0 ));

Else you can make a DEFINE field that meets this restrictions and use that as a single WHERE.

DEFINE FILE XXX
SPECIAL/A1= IF (( BOSBEGPRS NE 0 ) OR 
( BOSRCPPRS NE 0 ) OR 
( BOSHPPRS NE 0 ) OR 
( BOSADJPRS NE 0 ) OR 
( BOSRTNPRS NE 0 ) OR 
( BOSENDPRS NE 0 )) THEN 'N' ELSE 'Y';
END

....

WHERE SPECIAL EQ 'N';
....

quote:

WHERE ( COMPANY EQ '&COMPANY.(FIND COMPANY,COMPANY IN IRSUM).Company.' ) AND ( WAREHOUSE EQ '&WAREHOUSE.(FIND WAREHOUSE IN IRSUM).Warehouse.' ) AND ( LOGO EQ '&LOGO.(FIND LOGO IN IRUPC).Logo.' ) AND ( DATE GE '&FROMDATE.From Date.' ) AND ( DATE LE '&THRUDATE.Thru Date.' ) AND (( BOSBEGPRS NE 0 ) OR ( BOSRCPPRS NE 0 ) OR ( BOSHPPRS NE 0 ) OR ( BOSADJPRS NE 0 ) OR ( BOSRTNPRS NE 0 ) OR ( BOSENDPRS NE 0 ));

I assume you're using Dev Studio Report Painter to create your WHERE statement. I suggest splitting each of the statements in the WHERE to individual WHERE statements:

WHERE COMPANY EQ '&COMPANY.(FIND COMPANY,COMPANY IN IRSUM).Company.';
WHERE WAREHOUSE EQ '&WAREHOUSE.(FIND WAREHOUSE IN IRSUM).Warehouse.';
WHERE LOGO EQ '&LOGO.(FIND LOGO IN IRUPC).Logo.';
WHERE DATE GE '&FROMDATE.From Date.' AND DATE LE '&THRUDATE.Thru Date.';
WHERE BOSBEGPRS NE 0 OR BOSRCPPRS NE 0 OR BOSHPPRS NE 0 OR BOSADJPRS NE 0 OR BOSRTNPRS NE 0 OR BOSENDPRS NE 0;

Each of the WHERE statements will be available in the Where section of the Report Options dialog box, including the last one - it does not get truncated in my 7.6.5 Dev Studio Report Painter.

quote:

Each of the WHERE statements will be available in the Where section of the Report Options dialog box, including the last one - it does not get truncated in my 7.6.5 Dev Studio Report Painter.

I am using Report Painter in Dev Studio (7.6.6) and it is truncating exactly at 80 characters so that last line is too long. Is this truncation normal behavior of the software?

The 80 character limit is an historical thing. It should not be truncating at 80 characters.

I tried to reproduce this behaviour in R766 and couldn't. If you open a case, upload the original fex and master file I will take a look at it, just let me know what the case number is.

I would really look at breaking it up because if you use the resource layout and in 1 of the parameters you select all the whole where statement will be ignored. FOC_NONE throws away the whole statment that makes up any single command.

AND (BOSBEGPRS NE 0 OR BOSRCPPRS NE 0 OR BOSHPPRS NE 0 OR BOSADJPRS NE 0 OR BOSRTNPRS NE 0 OR BOSENDPRS NE 0);