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

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

Related posts about advantage-database-server