Kbase P20952: EQ causes error 223 with dynamic query
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/21/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
EQ and unknown value ('?') causes run time error 223 with dynamic query expression.
** Incompatible data types in expression or assignment. (223)
QUERY-OPEN for query requires a previous QUERY-PREPARE. (7312)
Cannot run GET methods on query until it is opened. (7313)
The problem does not occur with 9.1C.
CAUSE:
Bug# 20030320-006
FIX:
Replace 'EQ' in the query with '='.
e.g. Replace:
FOR EACH customer WHERE ? EQ ""
with
FOR EACH customer WHERE ? = ""