Kbase P133990: 4GL: Error (7) executing an OPEN QUERY statement in 10.1C
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/23/2010 |
|
Status: Verified
SYMPTOM(s):
4GL: Error (7) executing an OPEN QUERY statement
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):
Windows
OpenEdge 10.1C
CAUSE:
Bug# OE00159152
FIX:
Upgrade to 10.2A or later.
Workarounds:
1. Either remove the BREAK option from 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.
2. Or remove the DESCENDING option from the OPEN QUERY statement and instead define a descending index within the database.