Kbase P150042: Error 3541 when using CAN-FIND in OPEN QUERY statement
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/07/2009 |
|
Status: Unverified
SYMPTOM(s):
Error 3541 when using CAN-FIND in OPEN QUERY statement
OPEN QUERY q FOR EACH order WHERE CAN-FIND( invoice WHERE invoice.orderNum = order.orderNum )
CAN-FIND is invalid within an OPEN QUERY. (3541)
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
OpenEdge Category: Language (4GL/ABL)
FIX:
Use the FOR EACH or FIND statements if a CAN-FIND is necessary, or use a FIND trigger or IF statement to select out records with a CAN-FIND in a QUERY.