Kbase P71233: data type defined as number with decimals set to auto
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
ODBC DataServer
Progress 9.1D
SYMPTOM(s):
data type defined as number with decimals set to auto
Progress Data Type was decimal with 3 numbers to the right of the decimal point
Created records with numbers 1000.001 and 1000.002. Received duplicate index error message
ODBC DataServer to Access/97 Database
FIX:
Auto decimals in Access will only allow two decimals. Customer was trying to use three which was being truncated. The Duplicate Index error was a correct error message