Kbase P22447: Dynamics: Problem with the decimal values in the query when
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/1/2003 |
|
Status: Unverified
FACT(s) (Environment):
Dynamics 2.0A
SYMPTOM(s):
Dynamics: Problem with the decimal values in the query when using the
European numeric format
Using -E or -numsep 46 -numdec 44
CAUSE:
Missing quotes around the decimal value in the query prepare string e.g.:
FOR EACH customer WHERE customer_obj = 123456,78
FIX:
Surround the decimal value with the single quotes in the query prepare string:
FOR EACH customer WHERE customer_obj = '123456,78'