Kbase P21906: No records returned when using 'LIKE' in Actuate query
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Actuate 5.0
SYMPTOM(s):
SQL-92 connection
No records returned when using 'LIKE' in Actuate query
A query with 'LIKE' as opposed to '=' returns no results when there are matching records.
A query with the following line returns 42 records:
... AND "PUB"."Order"."Sales-Rep" = 'HXM'
A query with the following line returns 0 records:
... AND "PUB"."Order"."Sales-Rep" LIKE 'HXM'
These should return the same results.
CAUSE:
Actuate Bug SCR#53123
FIX:
Use '=' instead of 'LIKE' in the query to return the correct results.