2 Replies Latest reply: May 15, 2014 10:01 AM by Grant Perkins RSS

    ODBC Connection Issue - Numeric Data Truncated

    Erwin Sosropartono

      Hello,

       

      I am new to this forum and this is my first post. I am working on extracting data from our Lawson database via ODBC connection, but I am seeing that some digits on a field of numeric data type are being truncated. When I query the data using MS Access, the value of the same numeric field shows the correct amount. Therefore, I am ruling out the fact that the issue is caused by the database. I have just noticed this issue surfacing ever since I upgrade my Monarch from V8 to V9. Did I possibly configure something incorrectly during the install?

       

      Please help.

       

      Thank you,