bw1d |
Newbie |
|
|
|
|
None Specified |
|
Friday, May 13, 2016 |
Tuesday, May 24, 2016 7:30:14 PM |
2 [0.01% of all post / 0.00 posts per day] |
|
This appears to be an issue with the ODBC driver. Switching to the OLE DB Drivers for Oracle or JDBC drivers correct this issue.
|
The field result of a SQL Where clause is a database table column defined as NUMBER(38) [Oracle]. The SQL Where clause is improperly "truncating" the result.
Database column value: 7665848257543190376 MapForce SQL Where result: 7665848257543190000
Please advise how to correct such that the result return the entire number value.
|
|