what's this?

[pickerij@norbord.com]

Paul

Thanks. No case statement here. The offending statement seems to be this   
select statement:

>SELECT &
>IF "0000" = PERIOD-X OF FIBRE-SHIPMENTS OR &
>  T-PERIOD-ENDS LE &
>    ADDCENTURY(PERIOD-BEGINS OF FREIGHT-PERIODS, &
>       CENTURY(PERIOD-BEGINS OF FREIGHT-PERIODS))

Take it out and the request works. Remove either side of the or and the   
request works. I've settled for moving the add(...,cen(...)) stuff to a   
define and then comparing t-period-ends with the define. This seems to   
work too. Hope I don't find too many more!

JWP

 -----Original Message-----
From: paul@synergy.co.za
Sent: Monday, November 23, 1998 2:40 AM
To: Pickering, John NORBORD
Subject: RE: what's this?

Hi,
I have seen this once before and it had something to do with a case
statement.  Changing it to an if, then, else structure solved the   
problem.
Regards
Paul Howard

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.