Kbase P49740: Dynamics fixQueryString forces a decimal point separator even with -E
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/02/2009 |
|
Status: Verified
SYMPTOM(s):
Dynamics fixQueryString forces a decimal point separator even with -E
With the European Number format -E set for the session, a query string is defined with a WHERE clause and a decimal value fails to return any results for the query.
FACT(s) (Environment):
Dynamics 2.0A
Progress 9.1x
OpenEdge 10.0A
All Supported Operating Systems
CAUSE:
If a query string is defined with a WHERE clause and a decimal value, fixQueryString can convert the ',' decimal separator to a decimal point. So,
cQueryString = "for each xnfm_firma where xnfm_firma.login_company_obj = 71811,8594 no-lock"
after fixquerystring becomes:
cQueryString = "for each xnfm_firma where xnfm_firma.login_company_obj = 71811.8594 no-lock"
CAUSE:
Bug# OE00087717
FIX:
Upgrade to OpenEdge 10.0B or later release
In the later releases, the fixQueryString API has been deprecated and the formatting of the query string it was meant to achieve is handled elsewhere.