Re: Forms 4.5 and times

jmw_at_vena.med.utas.edu.au (John Williams) wrote:

>Help!
 

>I am trying to store some times, in the format HH:MM, and am not having an
>easy time of it, due to some pecularities (to say the least) of Forms 4.5.
 

>The database field is specified as 'datetime'. If I set a format mask of
>HH:MM, then I can't enter high or low value ranges - putting (e.g.) 6:00 or
>06:00 gives designer error 11330 - 'value is invalid - correct format is
>hh:mm.'
 

>I can get around that by writing an on-validate-field trigger, but when
>I enter data, eg 4:30, forms runtime re-writes it as 1:30 sometimes, or
>as 4:30 at other times. Similarly other values are not echoed as they are
>entered. I cannot rely on the correct value being put in the first time.
 

>Has anyone succeeded in storing times only using Forms 4.5? How did you
>do it? I'd be grateful for any ideas or assistance.

John,

First, you must use the correct format. 'MM' is the format for the two digit month representation. You want to use 'MI' for minutes. You might also want to use 'HH24' for army time, so your format might look like 'HH24:MI'.

Hope this helps.

chris.

--
Oracle Government
clbeck_at_us.oracle.com



>Thanx,

 


>John Williams, J.M.Williams_at_med.utas.edu.au


--
clbeck_at_us.oracle.com
Oracle Government