di new form instance di tambahkan
DECLARE
hour_timer TIMER;
one_minute NUMBER(7):=1000;
BEGIN
hour_timer:= CREATE_TIMER('alarm',one_hour,REPEAT);
END;
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, February 17, 2005 4:30 PM
Subject: Re: [indo-oracle] Re: setting time
>
> Coba script ini deh di when-timer-expired :
>
> DECLARE
> hour_timer TIMER;
> one_minute NUMBER(7):=1000;
> tg varchar2(20);
> BEGIN
> select to_char(sysdate + 1/1440,'hh24:mi:ss')
> into :jam from dual;
>
> tg := to_char(sysdate,'dd-mm-yyyy');
>
> :jam_in := to_date(tg||' '||:jam,'dd-mm-yyyy hh24:mi:ss');
>
> END;
>
> Semoga berguna
>
>
>
> Ermiriwani Pangloli
> Information System Department
> PT. Indonesia Toray Synthetics
> Tel : +62 (21) 520 0289
> Fax : +62 (21) 520 2041
> http://ermiriwani.blogspot.com
>
>
>
>
> "Clara Devi" <[EMAIL PROTECTED]>
> 17/02/2005 04:29 PM
> Please respond to indo-oracle
>
>
> To: <[email protected]>
> cc:
> Subject: Re: [indo-oracle] Re: setting time
>
>
>
> Saya juga sudah set di when-timer-expired selama 60 menit tp hanya untuk
> menampilkan alert kalau waktunya sudah 60 menit. Tp untuk menampilkan di
> form setting waktu nya seperti stopwatch atau countdown boleh tau ga
> caranya
> gimana?
>
> Sorry ya saya masih pemula di oracle jd lagi belajar
>
> thanks ya tuk masukannya
>
>
>
> ----- Original Message -----
> From: <[EMAIL PROTECTED]>
> To: <[email protected]>
> Sent: Thursday, February 17, 2005 3:22 PM
> Subject: Re: [indo-oracle] Re: setting time
>
>
> >
> > Kami kebetulan juga develop form seperti yang Anda maksud.
> > Untuk format jamnya, kami pake type data datetime dengan format mask
> > HH24:MM:SS
> >
> > Untuk membuat tampilan seperti stopwatch atau countdown, gunakan
> trigger
> > when-timer-expired
> >
> > Thanks
> >
> >
> >
> >
> >
> > "Clara Devi" <[EMAIL PROTECTED]>
> > 17/02/2005 03:09 PM
> > Please respond to indo-oracle
> >
> >
> > To: <[email protected]>
> > cc:
> > Subject: [indo-oracle] Re: setting time
> >
> >
> >
> > Untuk menampilkan format jam saya sudah dapat yaitu type data jangan
> > date tp Character
> > hanya permasalahan sekarang ada yang tau ga untuk membuat tampilan
> di
> > form seperti stopwatch atau countdown
> > yang sudah di setting selama 60 menit
> >
> > thanks
> >
> >
> >
> > ----- Original Message -----
> > From: Clara Devi
> > To: [email protected]
> > Sent: Thursday, February 17, 2005 2:08 PM
> > Subject: setting time
> >
> >
> > Dear all,
> >
> > Saya langsung aja mo nanya ni kira2 ada yang mengerti tampilan di
> form
> > oracle untuk menampilin waktu
> > misanya 01:00:00, saya harus setting dengan type data apa dan di
> > format mask apa seperti ini bisa HH24:MI:SS ?
> >
> > Saya pernah coba dgn tipe data Date dan format mask DD-MM-YYYY
> > HH24:MI:SS yang munculnya hanya 01-01-2005 00:00:00.
> > Menggunakan oracle developer form 6.0
> >
> > mohon bantuannya, thanks
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > --
> > -----------I.N.D.O - O.R.A.C.L.E---------------
> > Keluar: [EMAIL PROTECTED]
> > Website: http://indo-oracle.blogspot.com
> > -----------------------------------------------
> >
> > Bergabung dengan Indonesia Thin Client User Groups,
> > Terminal Server, Citrix, New Moon Caneveral, di:
> > http://indo-thin.vze.com
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > --
> > -----------I.N.D.O - O.R.A.C.L.E---------------
> > Keluar: [EMAIL PROTECTED]
> > Website: http://indo-oracle.blogspot.com
> > -----------------------------------------------
> >
> > Bergabung dengan Indonesia Thin Client User Groups,
> > Terminal Server, Citrix, New Moon Caneveral, di:
> > http://indo-thin.vze.com
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
>
> --
> -----------I.N.D.O - O.R.A.C.L.E---------------
> Keluar: [EMAIL PROTECTED]
> Website: http://indo-oracle.blogspot.com
> -----------------------------------------------
>
> Bergabung dengan Indonesia Thin Client User Groups,
> Terminal Server, Citrix, New Moon Caneveral, di:
> http://indo-thin.vze.com
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> --
> -----------I.N.D.O - O.R.A.C.L.E---------------
> Keluar: [EMAIL PROTECTED]
> Website: http://indo-oracle.blogspot.com
> -----------------------------------------------
>
> Bergabung dengan Indonesia Thin Client User Groups,
> Terminal Server, Citrix, New Moon Caneveral, di:
> http://indo-thin.vze.com
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
