Kbase P169071: Query-prepare fails with curly braces in query value
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/07/2010 |
|
Status: Unverified
SYMPTOM(s):
Query-prepare fails when the query value contains curly braces.
Data in database contains curly braces.
Example query: QUERY-PREPARE("FOR EACH Item WHERE ItemName matches '~{Fins~}'").
** "Fins" was not found. (293)
Running in a static query, this works fine.
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
CAUSE:
The query-prepare string will get compiled at runtime and by then the string will have been resolved to {Fins}.
FIX:
The escape character needs to be escaped as well so at runtime it is correct.
Changing the string to be '~~~{Fins~~~}'.