Altova User Support Forum

Welcome Guest

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.

Altova User Forums » Product/Technology Discussions » MapForce & MapForce Server » SQL Where NUMBER (long) conversion error

SQL Where NUMBER (long) conversion error

Options · View

Previous Topic · Next Topic

bw1d

Posted: Friday, May 13, 2016 2:58:50 PM

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.

bw1d

Posted: Tuesday, May 24, 2016 7:29:53 PM

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.

Users browsing this topic

guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

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

Email this topic

Watch this topic

Normal

Threaded

user forum