Kbase P31572: Decimal Value comparison fail when numeric format is set to
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/08/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Query-prepare() fail comparing decimal values when using numeric format set to European
Dynamic query fail using decimal data type
CAUSE:
When using European-format decimals and character variables it must always be enclosed in quotes.
FIX:
Use Quoter() function to convert the specified data type to CHARACTER and encloses the results in quotes when necessary.