Subject Re: [IBO] EditMask on IB_Query
Author Geoff Worboys
> These are accessed using a CAST AS TIME so I can sort on the
> start time.

> They display correctly, ( "hh:nn" ) but when I enter them to
> edit them ( "99:99" ) they both display 30:00 rather than
> the original time, enter a time and exit, the display is
> correct.

> Any ideas, I am supposed to be demoing this to the customer
> tomorrow, I can waffle, but a fix would be nice.

I know I am too late to help for your immediate required but anyway...

I cannot reproduce the problem here. Indeed I cannot setup the query
so that a datetime value cast as time is actually editable (it always
ends up readonly in my queries). I suggest that more information may
be required before I can understand what may be happening.

Geoff Worboys
Telesis Computing