Kbase P78259: Select fails if where clause longer than SQLWIDTH
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/04/2004 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.0A
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
SYMPTOM(s):
Select fails if where clause longer than SQLWIDTH
[DataDirect][ODBC OPENEGDE driver][OPENEDGE]Character string is too long (8184)
[JDBC OpenEdge Driver]:Character string is too long (8184)
Only if an index on that char field exists we get error (8184) ErrorCode=-20152
CAUSE:
Known problem
FIX:
Workaround by increasing the SQLWIDTH and limit the length of the string in the
where clause.