OraFAQ Forum: Forms » Synchronise Timing

Home » Developer & Programmer » Forms » Synchronise Timing

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Synchronise Timing [message #154052]

Thu, 05 January 2006 08:59

Shaila.Mehra
Messages: 88
Registered: July 2005
Location: mumbai

Member

Hi everybody.

Can someone tell me that how do i add item in my form which shows time in this format HH24:MI:SS.
And after opening the form it keeps on moving,
it automatically synchronize with real time.

I placed a item which shows time but it stuck after opening the form for showing current time it has to be refresh.

If this is possible then pass the information.
Waiting for reply..

Shaila.

Report message to a moderator

Re: Synchronise Timing [message #154130 is a reply to message #154052]

Thu, 05 January 2006 16:54

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Go to the Forms page on OTN (look in sticky) and have at look at the available Java bit and pieces. There may be something there.

David

Report message to a moderator

Re: Synchronise Timing [message #154159 is a reply to message #154052]

Fri, 06 January 2006 00:10

ashishmate
Messages: 90
Registered: February 2005
Location: Mumbai

Member

ashishmate@gmail.com

Hi

try this code

time is nondatabase displayitem
type datetime
formatmask HH24:MI:SS

in new form instance

DECLARE
	CNT NUMBER;
	hour_timer TIMER;
	P VARCHAR2(100);
	one_hour     NUMBER(7):=1000;
BEGIN
:time := sysdate ;--,'HH24:MI:SS');	
hour_timer:= CREATE_TIMER('FOR_POST',one_hour,REPEAT);
--p_message('ASHish Testing');		
end

in when time expire form level

:time := sysdate;--,'HH24:MI:SS');

Bye.......

Report message to a moderator

Re: Synchronise Timing [message #154365 is a reply to message #154159]

Sat, 07 January 2006 08:56

Shaila.Mehra
Messages: 88
Registered: July 2005
Location: mumbai

Member

Hello Ashish,
Thanx for cooperation.

When i run form using this code it just give the time for a second and then it change to date.

So whats the mean of declaring timer in this.

May be i am not getting the exact meaning of the code.
Shall you explain it bit more, if you have time otherwise....

Shaila

Report message to a moderator

Re: Synchronise Timing [message #154465 is a reply to message #154365]

Sun, 08 January 2006 17:55

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I believe that ashishmate is suggesting that you run a one hour 'timer' (read documentation for fuller explanation of timers). Although timers are okay for an hourly refresh and sometimes for a refresh every minute, a timer that refreshes every second or two seconds is, in my opinion, too expensive on network tranffic to be used for anything other that a screen that is only used by one or two people, and for a mission critical application. Try the Java alternative as it keeps the processing load on the PC, not on the network.

David

Report message to a moderator

Re: Synchronise Timing [message #154483 is a reply to message #154465]

Sun, 08 January 2006 23:02

ashishmate
Messages: 90
Registered: February 2005
Location: Mumbai

Member

ashishmate@gmail.com

Hi Shaila

I Dont Think ThereIs Any Thing To Explain.

But I'm Attaching FMB With This Post Pl. Chl It. (Hope This Will Solve U R Problem)

And One More Thing djmartin is Right

"too expensive on network tranffic"

But I Dont Know Any Thing About Java Alternative. Sad

Sad

If Still there Is Any Problem We Will Try To Sort It Out

Bye ........
ASHish

Report message to a moderator

Re: Synchronise Timing [message #154484 is a reply to message #154483]

Sun, 08 January 2006 23:13

ashishmate
Messages: 90
Registered: February 2005
Location: Mumbai

Member

ashishmate@gmail.com

Sorry im Not Able To Attach File Sad

Sad

If U Want I can Mail It TO U.
Bye
ASHish........

Report message to a moderator

Re: Synchronise Timing [message #154628 is a reply to message #154484]

Mon, 09 January 2006 16:54

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

After pressing Reply and entering your message, press the 'Browse' button, select the file you wish to upload, then press the 'Upload File'. This will add the file to the list just below the message box. Try it again.

David

Report message to a moderator

Re: Synchronise Timing [message #154643 is a reply to message #154628]

Mon, 09 January 2006 22:39

ashishmate
Messages: 90
Registered: February 2005
Location: Mumbai

Member

ashishmate@gmail.com

thanks Dj

i tryed that lasttime its not working

i'm geting this message

The file you are trying to upload does not match the allowed file types.
Allowed File Extensions: sh php cgi pl
Maximum File Size: 2048Kb
Maximum Files Per Message: 1

i think thes guys are ristricting FMB files which is realy poor idea Sad

Sad

Report message to a moderator

Re: Synchronise Timing [message #154646 is a reply to message #154643]

Mon, 09 January 2006 23:12

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Please look at http://www.orafaq.com/forum/m/154645/67467/#msg_154645. I'm not having any problems.

/forum/fa/736/0/

/forum/fa/736/0/

David

Attachment: Attachment.gif
(Size: 13.69KB, Downloaded 1058 times)

[Updated on: Mon, 09 January 2006 23:18]

Report message to a moderator

Re: Synchronise Timing [message #154651 is a reply to message #154643]

Mon, 09 January 2006 23:21

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Rename the 'FMB' to 'sh' and then attach it.

David

PS I have reported your problem and we'll find out what is happening.

Report message to a moderator

Re: Synchronise Timing [message #154652 is a reply to message #154483]

Mon, 09 January 2006 23:26

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Concerning the Java alternative, go to http://www.oracle.com/technology/sample_code/products/forms/index.html, search for the word 'clock', and work from there.

David

Report message to a moderator

Re: Synchronise Timing [message #154688 is a reply to message #154643]

Tue, 10 January 2006 04:01

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Quote:

think these guys are ristricting FMB files which is realy poor idea

Problem fixed.

Report message to a moderator

Re: Synchronise Timing [message #154710 is a reply to message #154688]

Tue, 10 January 2006 04:52

ashishmate
Messages: 90
Registered: February 2005
Location: Mumbai

Member

ashishmate@gmail.com

Thanks Dj and Frank Naude.

Hi Shaila

I Dont Think ThereIs Any Thing To Explain.

But I'm Attaching FMB With This Post Pl. Chl It. (Hope This Will Solve U R Problem)

And One More Thing djmartin is Right

"too expensive on network tranffic"

If Still there Is Any Problem We Will Try To Sort It Out

Attachment: TIMER.fmb
(Size: 48.00KB, Downloaded 1127 times)

Report message to a moderator

Re: Synchronise Timing [message #154754 is a reply to message #154710]

Tue, 10 January 2006 07:14

Shaila.Mehra
Messages: 88
Registered: July 2005
Location: mumbai

Member

Thanx Ashish..
Actually i was doing mistake in coding.

Shaila.

Report message to a moderator

Previous Topic:	fetching records from one table and populating to multi record block
Next Topic:	JInitiator 1.3 Fatal Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:23:12 CDT 2024