Components for Delphi and C++ Builder.

Hi,

I have the following strange issue with all datetime fields in my dbgrideh.
When I enter any time value (like 11:23, or 19:23) and I exit that column, the value is fine
But when I come back to that column (i.e. that column gets the focus), the value changes itself to 18:23!

The minute part remains correct (i.e. thus I entered), but the hour part becomes always 18, whatever the original value was!
The dataset is empty and cachedupdate it set tu true.
I only have problem with the time datatype.
Also, when I change the datatype of that field to string in the memtable component, the grid doeasnot seems to take it into account as it complans that 99:99 is not a datetime value.

What is the problem here???

Environment:
ehlib 6.3.168
components used:
dbgrideh,
memtableeh
datasetdrivereh
adoquery

Hello

To understand the reason of this problem we need to reproduce same error on our computer.
Can you create and send us Demo project that shows it?

Best regards
Admin

_________________
Best regards
Admin

Hi,

Attached the demo project.
You can enter whatever time you want (for example 12:34), once you leave the time field the value seems to be fine, but when you select it again the hour part of the time will become 18.

Hi,

EditMask for time fields isn't 00:00, but !90:00:00;1;0

Rico

Rico,



It doesn't solve my problem.
First of all I do not want to enter the second part of the time
And if I use the editmask without the second part, like !90:00;1;0 in this case when I'm coming back to that field (time is getting the focus) the hour part is now fine, but tie minute part is change to 00!!! So my value of 11:23 is changes to 11:00!!!

Or
If I'm leaving the editmask as You've indicated AND keeping the displaymask as HH:NN, I'll get a runtime error message saying 11:23: is not a valid date and time.

So my question is simple: How can I enter just a time without seconds (HH:NN)?

Hi boumboum,

See my demo to do what you need
I use onSetText and onGetText events

Hi rico,

It's kind a working but if before entering any text you click an the dropdown button, you will have an error message saying " : is not a valid date and time". So the gettext/settext is not working thare.
Of course there is a way to set the ButtonStyle to cbsNone but in this case you will not have the possibility to define a dropdown form.

Anyway, thanks for the solution. It's not quite straightforward nor really out of the box but this is a workaround.

Hi boumboum,

I don't use the new feature dropDownForm yet, but strange that you can't define it...
In this case add an edit button and create your own form (don't use dropDownButton style).

PS : I had the same problem, look at this : viewtopic.php?f=5&t=144

Rico