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.
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.