Kbase P14675: Error# 223 when using dynamic queries with wrong data type v
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/03/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Error# 223 when using dynamic queries
** Incompatible data types in expression or assignment. (223)
CAUSE:
Wrong data type value in the query string.
FIX:
Check query string used in the dynamic query. This can be achieved by
displaying the query string prior to call QUERY-PREPARE method i.e.:
DEFINE VARIABLE qh AS WIDGET-HANDLE NO-UNDO.
DEFINE VARIABLE cQuery as CHARACTER NO-UNDO.
DEFINE VARIABLE MyValue as CHARACTER NO-UNDO.
MyValue = "SomeValue".
CREATE QUERY qh.
qh:SET-BUFFERS(BUFFER MyTable:HANDLE).
cQuery = "FOR EACH MyTable NO-LOCK WHERE MyTable.MyField = " + "'" +
STRING(MyValue) + "'" .
MESSAGE cQuery VIEW-AS ALERT-BOX INFO BUTTONS OK.
qh:QUERY-PREPARE(cQuery).
qh:QUERY-OPEN.
.
.
.