Money type field returns Dollar, but regional set to UK (Windows 7)

Question

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.

Answer 1

Can you discern any consistencies as to when the switch occurs? I can't tell from your description if you are doing SQL using ARC or if it is in your application (and, if so, what is the application written with) or if you are gathering data into Excel.

Since this is, seemingly, random more details will be needed to solve this, other than if the Advantage team "has seen the problem already". They'll be piling on later, I'm sure, but the questions I'm asking will be needed if they haven't already seen the problem.

Answer 2

It returns the $ sign in ARC and when I export to Excel and when I obtain money data type fields using Delphi.

I have tried to keep and eye on things to see if I can notice when it switches, but there's apparently no pattern to it. I can run one query, then run it a few minutes later without making any changes and it will come back with a different currency symbol.

Although at the moment it seems to be stuck on $. I have just updated to the latest release and it's still the same.

Answer 3

No, I can't find any pattern to it at all. But it does now seem to be stuck on $! Everyone else who is connected, so it seems to be something to do with Windows 7.

It happens in Data Architect and when I use Delphi to obtain results from money fields.

Answer 4

If I set the regional settings currency, it (briefly) works. But then it just reverts back!

Answer 5

I've found some posts in various places about the problem with Delphi on Windows 7. The workaround seems to be to add the following two lines into the initialzation section of the project.

SetThreadLocale(LOCALE_USER_DEFAULT); GetFormatSettings;