Subject Re: [IBO] Masking problem with TDateTime field
Author Helen Borrie
At 07:08 AM 17/08/2006, you wrote:
>I have a TDBEdit connected to an IBOQuery field that's a TDateTime.
>When this field gets displayed, I get a validation error because
>there's some strange interaction between whatever formats the field
>and the masking stuff.
>For instance, if I use today's date (8/16/2006), then the fact that
>there's no leading zero seems shift things over, so that when the
>data gets copied into TDBEdit.Text behind the scenes, it comes out
>as 8//6//006.
>If I then put the cursor on the field and give it focus, the text
>immediately changes to 8/16/2006 and all is well.
>Naturally, I can't reproduce this in an isolated case, it only
>happens when the whole big ugly application is running. I suspect
>it has to do with the fact that this field gets changed via a
>different query and the one that's being used for display gets
>refreshed, but I can't prove it yet.
>Has anyone ever seen anything like this?

It sounds as though the data might be stored in some string type,
rather than a date/time type.