Rank: Newbie
Joined: 5/13/2016 Posts: 2
|
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.
|
Rank: Newbie
Joined: 5/13/2016 Posts: 2
|
This appears to be an issue with the ODBC driver. Switching to the OLE DB Drivers for Oracle or JDBC drivers correct this issue.
|