Results 1 to 3 of 3

Thread: Decimal places

  1. #1
    Join Date
    Oct 2004

    Unanswered: Decimal places

    Hi Forum,

    can someone help shed some light? Why does a database app suddenly start displaying numbers as if they have been multiplied by 100? I have noticed this in 2 different DB's here. They both have tables linked to a DB on our servers via OBDC (I don't know if that is relevant or not, but the connected DB shows the values correctly). If I reconnect to the ODBC datasource the problem appears to go away.

    Regards................... Nick Ellis

  2. #2
    Join Date
    Jan 2007
    Provided Answers: 12
    This may sound like a stupid question, but is it displaying as 1.00 (2dp) not as 100?

    It might be worth posting a few before and after examples!
    Home | Blog

  3. #3
    Join Date
    Oct 2004

    Decimal places2

    mmm, sorry, I should have given an example to start with.

    A value should be displayed as 4.00 , what I get is 400.00 .

    The values in the main DB are correct, and as I said in the connected DB (to begin with) also correct. At some point (I can't define what triggers it)they start to be displayed incorrectly. As both of the DB App's (one written by me, one from an external company) produce the same error, which is intermittent, I wondered if it has something to do with the ODBC connection settings? As I said, reconnecting the Datasource seems to resolve the problem.

    Regards... Nick Ellis

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts