IMPORTANT:
this is not a Support Forum! Experienced users might answer from time to time questions posted here. If you need a professional and reliable answer, or if you want to report a bug, please contact Altova Support instead.

Profile: bw1d
About
User Name: bw1d
Forum Rank: Newbie
Real Name:
Location
Occupation:
Interests:
Gender: None Specified
Statistics
Joined: Friday, May 13, 2016
Last Visit: Tuesday, May 24, 2016 7:30:14 PM
Number of Posts: 2
[0.01% of all post / 0.00 posts per day]
Avatar
Last 10 Posts
Topic: SQL Where NUMBER (long) conversion error
Posted: Tuesday, May 24, 2016 7:29:53 PM
This appears to be an issue with the ODBC driver. Switching to the OLE DB Drivers for Oracle or JDBC drivers correct this issue.
Topic: SQL Where NUMBER (long) conversion error
Posted: Friday, May 13, 2016 2:58:50 PM
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.

Use of the Altova User Forum(s) is governed by the Altova Terms of Use.