UniDac Dates and Windows 7 regional settings.

nokib8 · Post by **nokib8** » Fri 25 Jun 2010 06:15

Hello.
The date format in my Win7 regional settings is dd.mm.yyyy.
Dates shown in TCRDBGrid, from my Firebird MyDateField, is on format mm/dd/yyyy.
If I change the regional settings in Win7 the TCRDBGrid changes accordingly, but only one at a time, when focused.
Scrolling through the whole table will then set all dates to the regional settings.
So, when MyProgram is closed and restarted, then it's back to view mm/dd/yyy and I have to repeat the change of regional settings and scrolling through the entire table to get the right view format.
This must be a bug in the Grid?

Kai Inge

hughespa · Post by **hughespa** » Sat 26 Jun 2010 08:20

I posted a reply in:
embarcadero.public.delphi.database.general
which may help.

Regards, Paul.

bork · Post by **bork** » Wed 30 Jun 2010 13:56

Hello

The behavior of TCRDBGrid is inherited from TCustomDBGrid and to show date TCRDBGrid gets text value of date as TDateTimeField.GetText (see the DB unit). Now TCRDBGrid is distributed for free and we don't add any new features or new behavior to this product. You can ask Embarcadero to change the behavior of the TDateTimeField.GetText function. Also TCRDBGrid is distributed with source code and you can improve its behavior yourself.