Kbase P129787: SQL: sqlDescribeParam returns wrong DecimalDigits information for a parameter marker associated with
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/20/2008 |
|
Status: Unverified
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1B
OpenEdge 10.1C
SYMPTOM(s):
SQL: sqlDescribeParam returns wrong DecimalDigits information for a parameter marker associated with a prepared SQL statement
The ODBC SQLDescribeParam fails to return the correct number of decimal digits of parameter marker associated with a prepared SQL statement.
Executing the ODBC API SQLPrepare function followed by SQLDescribeParam function against the following SQL statement incorrectly returns DecimalDigits = 0 as opposed to the expected correct DecimalDigits = 2 result.
SELECT
Balance
FROM
PUB.Customer
WHERE
Balance * 1.53 = ?
CAUSE:
Bug# OE00166030
FIX:
Upgrade to OpenEdge 10.1C01 or later