Re: Date/Time fields in Oracle Forms 6.0

From: Mike Rainville <CCRE_at_musica.mcgill.ca>
Date: Tue, 28 Mar 2000 23:18:27 GMT
Message-ID: <38E13DBC.3DB79F6D_at_musica.mcgill.ca>


Dear Marie,

        If they DRAG (hold LEFT button down) the mouse cursor across the part of the date and time they want to change, they'll be able to type replacement text, and watch it overlay the old value. That's just a standard Windows feature for an updateable Oracle field.

(You could access the same features programmatically with CUT_REGION, PASTE_REGION, or SELECT_ALL builtins.)

        To obtain the kind of control you describe would probably require putting each part of the date and time in a separate field just big enough to hold it, selecting or validating each one, and then concatenating(||) the validated fields as a character string to store in a full datetime field. [1999]v[March]v[17]v[08]v:[30]v[a.m.]v
v is a drop down menu.

        I prefer to use the Calendar.PLL for dates; see Tools\DevDem60\Demo\Forms\Calendar.Frm

Good luck,

Mike Rainville
Montreal, QC, Canada

Marie Henebury wrote:

> We have date/time fields in our application and our users would like to be
> able to select a portion of the date by just double clicking on that portion
> of the field. For example, with a date of 27-MAR-2000 12:00. The user
> would like to be able to double click on the portion between the two dashes,
> in this case, MAR, and have that highlighted so that they can change it
> without having to do anything else.
>
> Is it possible to do this?
>
> Please respond to my e-mail address as well as to the news group. Any
> suggestions would be appreciated.
>
> Thanks
> Marie Henebury
> Fifth Dimension
>
> marie_at_fifthd.ca
Received on Wed Mar 29 2000 - 01:18:27 CEST

Original text of this message