Kbase P126107: 4GL/ABL: Error (7) executing an OPEN QUERY statement with the BREAK BY option.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/14/2009 |
|
Status: Verified
SYMPTOM(s):
4GL/ABL: Error (7) executing an OPEN QUERY statement with the BREAK BY option.
SYSTEM ERROR: Illegal choice found in semantic stage. (7)
The code generating the error is similar to the following:
DEFINE QUERY qCustomer FOR Customer SCROLLING.
OPEN QUERY qCustomer FOR EACH Customer NO-LOCK BREAK BY Customer.CustNum DESCENDING.
GET FIRST qCustomer NO-LOCK.
MESSAGE NAME
VIEW-AS ALERT-BOX INFO BUTTONS OK.
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.0x
OpenEdge 10.1A
OpenEdge 10.1B
CAUSE:
Syntax error. Prior to OpenEdge 10.1C, the BREAK BY option was not supported with the OPEN QUERY statement.
CAUSE:
Bug# OE00159152
FIX:
Upgrade to OpenEdge 10.1C or later. If upgrading to OpenEdge 10.1C or later is not feasible, then replace the BREAK BY option with the BY option in the OPEN QUERY statement. For example:
DEFINE QUERY qCustomer FOR Customer SCROLLING.
OPEN QUERY qCustomer FOR EACH Customer NO-LOCK BY Customer.CustNum DESCENDING.
GET FIRST qCustomer NO-LOCK.
MESSAGE NAME
VIEW-AS ALERT-BOX INFO BUTTONS OK.