Re: SQL*Forms and the 21st Century

stevec_at_zimmer.CSUFresno.EDU (Steve Cosner) wrote:
>
> In article <3svdmp$nek_at_mccoy.ici.net> jack_at_ici.net (Jack Bell) writes:
> >Greetings Oracle users!
> >
> >As the 21st Century approaches a problem has surfaced with some
> >SQL*Forms 3.0 data input forms I created. It involves the
> >evaluation of dates which occur beyond 31-DEC-1999. The forms
> >use the default DD-MON-YY format for date display. Users
> >noticed that dates entered with 00 for the year were always
> >evaluated as occuring in 1900. To correct this I made an
> >on-validate-field trigger as follows:
> >
(snip)

> First, we do something similar to your method, and the form seems to
> remember the correct century set by the on-validate-field trigger
> process. Are you sure the add_months procedure works right? Is
> add_months your own procedure? I can't find it in any
> documentation. (I use Forms 4.5, so this may be different.)
>

(snipsnip)

In Forms 4.5 you could just use RR as year format. Received on Mon Jul 03 1995 - 00:00:00 CEST