Money type field returns Dollar, but regional set to UK (Windows 7)
Posted
by Gareth
on Stack Overflow
See other posts from Stack Overflow
or by Gareth
Published on 2010-06-10T10:24:17Z
Indexed on
2010/06/11
12:13 UTC
Read the original article
Hit count: 162
advantage-database-server
Hi, On a Windows 7 machine with Advantage Data Architect version 9.10.0.11, money type data is returned as Dollars, instead of Pounds. Sometimes, it will suddenly switch to Pounds, without me changing any settings. Everything else returns Pounds correctly (regional settings is UK with £ as the currency symbol).
Has anyone else had this problem and/or found a solution?
If I run any reports using the money data type field I can't be sure that it's going to be accurate.
And no, I can't change the field type and handle the currency symbol myself.
Any help would be appreciated.
© Stack Overflow or respective owner