RE: Setting Clock in Oracle Application

A quick try for this worked:

create a display field call time_disp, for example, in a control block. Set its type to datetime.
Set its format mask to hh:mi:ss
Set its default to $$DATE$$

Create a timer at form creation:

   declare

      t timer;
   begin

      t := create_timer ('T_TIME_DISP', 1000); -- expires at 1000 millisec (1 sec).

   end;

Create a when-timer-expired trigger on the form. In it, set the time_disp field := sysdate;

That worked for me.

hth,

Yosi

> -----Original Message-----
> From: drichard_at_mtlindia.com [mailto:drichard_at_mtlindia.com]
> Sent: Tuesday, January 23, 2001 6:51 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Setting Clock in Oracle Application
>
>
>
>
> Setting Clock in Oracle Application :
>
> In forms 4.5 application,
> I want to include the clock in the main window of my software.
> Is it possible ? How to do ? Please help
>
> Richard
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: drichard_at_mtlindia.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Jan 23 2001 - 09:59:54 CST