Hello,

a customer has an application i did for him with D5 and DBISAM V4.26 Build 3. It run all the time under XP with no problem. Now he changed to Windows 7 Starter Edition.

Problem are the fields i set up as Currency in table structure. Under XP they were shown correct like this 12,34 €. Under Windows 7 now they are shown like this $12.34
We have checked the Windows 7 region settings, but they all are correct, € as symbol and , as decimal seperator. Under my Windows 7 Ultimate all is shown correctly.

Any suggestions?

Thomas,

<< Problem are the fields i set up as Currency in table structure. Under XP
they were shown correct like this 12,34 €. Under Windows 7 now they are
shown like this $12.34 We have checked the Windows 7 region settings, but
they all are correct, € as symbol and , as decimal seperator. Under my
Windows 7 Ultimate all is shown correctly. >>

This functionality is controlled by Delphi 5 RTL and DB units, not by
DBISAM.  You need to verify that the Delphi 5 RTL is operating correctly
under Windows 7.

Does the DBISAM Database System Utility display the data properly in a grid
for the same table ?

--
Tim Young
Elevate Software
www.elevatesoft.com

I've had similar issues with the date format and Windows 7. Under XP and
Vista OK but under Windows 7, the app just cannot pick up the date format
from the Windows Control Panel Regional settings.

We resolved it as follow :

In the Windows Control panel, change the "Format" setting to anything else
like "English (Another Country) etc", click [Apply]. Now change it back to
your desired locale. This forces Windows 7 to save the date format such that
our app can retrieve it. It resolves the problem with the date format. I
think it might work for Currency format as well.

Appreciate if you can post the results here. Thanks.

Regards
Gregory Sebastian

Gregory Sebastian wrote:

> I've had similar issues with the date format and Windows 7. Under XP
> and Vista OK but under Windows 7, the app just cannot pick up the
> date format from the Windows Control Panel Regional settings.
>
> We resolved it as follow :
>
> In the Windows Control panel, change the "Format" setting to anything
> else like "English (Another Country) etc", click [Apply]. Now change
> it back to your desired locale. This forces Windows 7 to save the
> date format such that our app can retrieve it. It resolves the
> problem with the date format. I think it might work for Currency
> format as well.
>
> Appreciate if you can post the results here. Thanks.
>
> Regards
> Gregory Sebastian

We've found the same issues with both date and currency on W7 and
Server 2008.

It seems that if the correct locale info is selected during the
installation, even though it will then show  correctly on the regional
settings screen, the OS returns the wrong info when a program requests
it.

But we've found that in many cases, it's not enough to simply change
the locale, apply it and then change it back.

We always perform a restart after changing it to the WRONG locale, and
before returning it to the correct locale.

--

"Gregory Sebastian" wrote:

Appreciate if you can post the results here. Thanks.


I did like you described and now it works as expected. Thank you for the hint.

Thomas Grimm wrote:
> Hello,
>
> a customer has an application i did for him with D5 and DBISAM V4.26 Build 3. It run all the time under XP with no problem. Now he changed to Windows 7 Starter Edition.
>
> Problem are the fields i set up as Currency in table structure. Under XP they were shown correct like this 12,34 €. Under Windows 7 now they are shown like this $12.34
> We have checked the Windows 7 region settings, but they all are correct, € as symbol and , as decimal seperator. Under my Windows 7 Ultimate all is shown correctly.
>
> Any suggestions?
>

Thomas,

The most reliable solution for the Windows-7 Date&Currency issue is to
force your required Regional Settings in the OnCreate event of your main
form.

e.g.

CurrencyString := '$';
ShortDateFormat := 'dd/MM/yyyy';

Norman Rorke
norman.r@desktopfinancials.com

Norman Rorke wrote:

>The most reliable solution for the Windows-7 Date&Currency issue is to
>force your required Regional Settings in the OnCreate event of your main
>form.

>CurrencyString := '$';
>ShortDateFormat := 'dd/MM/yyyy';

Your are right and not.

That's what regional settings are for, so why i have to set them in my application. Further, my application is not only used in the Euro region, but also in neighbor countries as switzerland e.g., where CHF is the symbol. So system-wide settings are the issue. thats the theory.
BTW: I had never thought that there can be a problem in a new OS in such a fundamental task.

In reality there is the Windows 7 issue. And in switzerland e.g. the most Windows installations are setup for Euro than for CHF. So i get a lot of questions from switzerland where in my application are the settings for the currency?
So set it up in own application would be a solution. Or set the field type to BCD or float than currency.

Gregory,

<< I've had similar issues with the date format and Windows 7. Under XP and
Vista OK but under Windows 7, the app just cannot pick up the date format
from the Windows Control Panel Regional settings. >>

Wow, I'll have to check this out and post a technical bulletin.  I had no
idea that there was such a basic functionality issue with Windows 7.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


Its also been reported on the CodeGear ngs

Roy Lambert

> Its also been reported on the CodeGear ngs
Yeah, that's how I found the workaround, from another ng.

Before that, this issue was also causing me a lot of grief when Win 7 was
first released. The app always uses the default date format (and now
currency format as well) when Win 7 was first installed unless you jump
through all the hoops as described.

Apparenly it was already reported to MS by one of the members then and this
was around March when I first read about it. Looks like the issue is still
here.

Cheers
Gregory Sebastian