I received the daily "Progress Alert and Notification Service: OpenEdge" yesterday with the following 'solution':
I believe it is time for some code rewriting if one needs to have more than 255 'or' statements inside a where at the same time.
ID: P187469
Title: "Using more than 255 OR's inside a WHERE clause crashes application"
Created: 05/10/2011
Last Modified: 07/03/2011
Status: Unverified
Symptoms:
The procedure has a WHERE clause inside a FOR EACH.
The WHERE clause contains more than 255 OR comparisson
example:
FOR EACH piaco WHERE
piaco.CONTO = 1117 OR
piaco.CONTO = 1118 OR
piaco.CONTO = 966 OR
.
.
.
END
Facts:
All Supported Operating Systems
OpenEdge 10.1C
OpenEdge 10.2x
Cause:
OE00207474
Fixes:
None at the moment.
Try to limit the WHERE clause to less than 255 OR's
I believe it is time for some code rewriting if one needs to have more than 255 'or' statements inside a where at the same time.