Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 10 of 12 total |
Currency and Windows 7 |
Tue, Jun 1 2010 11:16 AM | Permanent Link |
Thomas Grimm | 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? |
Tue, Jun 1 2010 3:17 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Tue, Jun 1 2010 10:42 PM | Permanent Link |
Gregory Sebastian | 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 |
Wed, Jun 2 2010 6:43 AM | Permanent Link |
Roger-Ash | 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. -- |
Wed, Jun 2 2010 6:54 AM | Permanent Link |
Thomas Grimm | "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. |
Wed, Jun 2 2010 9:44 PM | Permanent Link |
Norman Rorke | 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 |
Thu, Jun 3 2010 7:12 AM | Permanent Link |
Thomas Grimm | 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. |
Sat, Jun 5 2010 12:34 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Sun, Jun 6 2010 3:35 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
Its also been reported on the CodeGear ngs Roy Lambert |
Sun, Jun 6 2010 7:23 PM | Permanent Link |
Gregory Sebastian | > 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 |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |