| |
|
Limitations
- ODBC 4 ALL only works with 32 bit ODBC.
- Maximum digits allowed for numeric fields are 19 (included the decimal separator), so don't set DecNo=13 unless you really need it, or the integer numeric part will be limited to values not greater than 99999.
For example:
DecNo = 13 - Value = 12345.67 - Odbc4All retrieve it as: 12345.6700000000000
DecNo = 13 - Value = 123456.7 - Odbc4All shows a "Data with error" (because 13 decimals + 6 integers + the decimal separator = 20) and the value is retrieved as 0.0000000000000
DecNo = 12 - Value = 123456.7 - Odbc4All retrieve it as: 123456.700000000000
- Precision is limited to 16 digits. This means that if you set DecNo=13, the value
123.1234567890123 will be correctly retrieved, while the value
1234.1234567890123 will be retrieved as 1234.1234567890120, by loosing the last digit.
- If your DB Server allows you to set an higher precision to numeric fields, you should retrieve them as text.
For example: SQL=Select CAST( long_field as CHAR ) from MyTable
|
|
