Home » Developer & Programmer » Forms » timer related problem /form cursor keep refreshing
timer related problem /form cursor keep refreshing [message #604228] Thu, 26 December 2013 08:15 Go to next message
jgjeetu
Messages: 203
Registered: July 2013
Location: India
Senior Member
i have one form and there is a tab canvas with 5 tab pages.
1st tab page is for welcome screen
there are three items , current date ,current time and logged in user (item type is text_item for all)
i have created timer for continuos change of time
and the timer type is repeat .
Now the problem is
when i navigate to other tab pages the cursor keep refreshing on other pages too.
thats why i am having a problem in selecting the data from combo_box type items

Please tell me how to handle this.

[Updated on: Thu, 26 December 2013 08:17]

Report message to a moderator

Re: timer related problem /form cursor keep refreshing [message #604230 is a reply to message #604228] Thu, 26 December 2013 08:24 Go to previous messageGo to next message
mughals_king
Messages: 351
Registered: January 2012
Location: pakistan
Senior Member
dear upload screen shot or fmb will check
Re: timer related problem /form cursor keep refreshing [message #604233 is a reply to message #604230] Thu, 26 December 2013 08:33 Go to previous messageGo to next message
jgjeetu
Messages: 203
Registered: July 2013
Location: India
Senior Member
check fmb file in previous topic i have provided
Re: timer related problem /form cursor keep refreshing [message #604240 is a reply to message #604233] Thu, 26 December 2013 10:00 Go to previous messageGo to next message
Littlefoot
Messages: 19305
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How are we supposed to know which one of all those topics is a "previous" one? Note that forum discussions are dynamic, and topics that contain most recent messages raise to the top of the list, so "previous" is very doubtful. Maybe you'd rather post a link to that topic (or even better, a message that contains information you refer to). Doing so, you'd avoid possible confusion.
Re: timer related problem /form cursor keep refreshing [message #604241 is a reply to message #604240] Thu, 26 December 2013 11:16 Go to previous messageGo to next message
jgjeetu
Messages: 203
Registered: July 2013
Location: India
Senior Member
@littlefoot ,actually i posted 2 queries simultaneously and he gave reply to both queries thats why he knows which one is previous , and there is only one fmb file for both queries that i have aalready attached in my previous post.
Thanks
Re: timer related problem /form cursor keep refreshing [message #604328 is a reply to message #604241] Sat, 28 December 2013 13:13 Go to previous messageGo to next message
mughals_king
Messages: 351
Registered: January 2012
Location: pakistan
Senior Member
Brother Jgeetu can you send me tables structure b'coz i need to run your .FMB to solve this refreshing problem .



Regard
Mughal

[Updated on: Sat, 28 December 2013 13:36]

Report message to a moderator

Re: timer related problem /form cursor keep refreshing [message #604335 is a reply to message #604328] Sat, 28 December 2013 15:52 Go to previous messageGo to next message
mughals_king
Messages: 351
Registered: January 2012
Location: pakistan
Senior Member
PROBLEM IS SOLVED

Dear corrected your fmb why you used on block-level

when-new-block-instance------------TOTALLY WRONG CODE-----
declare
t timer;
begin
t:=create_timer('t1',1000,repeat);
end;
select sysdate into :welcome.date from dual;
NULL;
-----------------------------------------


NOW CORRECT WAY TO SOLVE THIS PROBLEM 

WHEN-NEW-FORMS-INSTANCE----TRIGGER

select sysdate into :welcome.date from dual;

DECLARE 
   CurrTime TIMER; 
    OneSec CONSTANT NUMBER := 1000; 
BEGIN 
    CurrTime := CREATE_TIMER('CURRTIME',OneSec,REPEAT); 
END;  


WHEN-TIMER-EXPIRED------TRIGGER

DECLARE 
ExpTimer VARCHAR2(40) := Get_Application_Property(TIMER_NAME); 
vTime VARCHAR2(30):= :SYSTEM.CURRENT_DATETIME; 

BEGIN 

IF ExpTimer = 'CURRTIME' THEN 
   Welcome.TIME := SUBSTR(vTime, instr(vTime,' ')+1); 
END IF; 
END;


See this corrected fmb file download this

Regard
Mughal Cool

[Updated on: Sat, 28 December 2013 15:55]

Report message to a moderator

Re: timer related problem /form cursor keep refreshing [message #604336 is a reply to message #604335] Sat, 28 December 2013 17:16 Go to previous messageGo to next message
mughals_king
Messages: 351
Registered: January 2012
Location: pakistan
Senior Member
Brother take .FMB your both problems SOLVED "Timer" and "Horizontal Toolbar"




Regard
Mughal Cool
Re: timer related problem /form cursor keep refreshing [message #604337 is a reply to message #604336] Sat, 28 December 2013 17:18 Go to previous messageGo to next message
mughals_king
Messages: 351
Registered: January 2012
Location: pakistan
Senior Member
screen shot

[Updated on: Sat, 28 December 2013 17:21]

Report message to a moderator

Re: timer related problem /form cursor keep refreshing [message #604347 is a reply to message #604337] Sun, 29 December 2013 03:19 Go to previous messageGo to next message
jgjeetu
Messages: 203
Registered: July 2013
Location: India
Senior Member
http://www.mediafire.com/convkey/5467/9euxk8bphqj7xrqfg.jpg
./fa/11512/0/
http://www.mediafire.com/convkey/4dd4/gxqm1qhds6rj128fg.jpg


MUGHAL BRO AS YOU SEE IN THESE PICS, THIS IS THE SCREENSHOT WHICH I TAKEN AFTER RUNNING YOUR.FMB FILE ,THE CURSOR IS STILL REFRESHING
SO THE PROBLEM STILL EXISTS.
& I DONT KNOW MUCH HOW TO USE TIMER , I JUST SAW AN 1 MINUTE VIDEO OVER YOUTUBE THAT TOO WITHOUT AUDIO ,JUST TOOK IDEA FROM THAT AND USED IN MY PROJECT TO DISPLAY THE CONTINUOS CHANGE OF TIME, SO PLEASE EXPLAIN WHATS THE PURPOSE AND USES OF TIMER
AND THIS CODING ALSO:-
WHEN-TIMER-EXPIRED------TRIGGER

DECLARE 
ExpTimer VARCHAR2(40) := Get_Application_Property(TIMER_NAME); 
vTime VARCHAR2(30):= :SYSTEM.CURRENT_DATETIME; 

BEGIN 

IF ExpTimer = 'CURRTIME' THEN 
   Welcome.TIME := SUBSTR(vTime, instr(vTime,' ')+1); 
END IF; 
END;



  • Attachment: 2.jpg
    (Size: 141.80KB, Downloaded 123 times)

[Updated on: Sun, 29 December 2013 07:30]

Report message to a moderator

Re: timer related problem /form cursor keep refreshing [message #604367 is a reply to message #604347] Sun, 29 December 2013 08:02 Go to previous messageGo to next message
mughals_king
Messages: 351
Registered: January 2012
Location: pakistan
Senior Member
Dear right now i have checked this .fmb time and again but with me its 100% working there is no CURSOR REFRESHING despite this let me check thoroughly this .fmb again. I will let you know.

Regard
Mughal


[Updated on: Sun, 29 December 2013 08:03]

Report message to a moderator

Re: timer related problem /form cursor keep refreshing [message #604370 is a reply to message #604367] Sun, 29 December 2013 08:59 Go to previous messageGo to next message
mughals_king
Messages: 351
Registered: January 2012
Location: pakistan
Senior Member
No dear no such Error here like CURSOR REFRESHING i have had ran this file almost 30 time anywayz i already requested to Sir @Littlefoot also in his private msg. he will download and will check thoroughly. and will point out if cursor will be refreshing as you said.

[Updated on: Sun, 29 December 2013 09:03]

Report message to a moderator

Re: timer related problem /form cursor keep refreshing [message #604374 is a reply to message #604370] Sun, 29 December 2013 11:23 Go to previous messageGo to next message
jgjeetu
Messages: 203
Registered: July 2013
Location: India
Senior Member
@Mughal Bro, these screenshots has been taken after running same fmb file which you gave , you can see clearly in screenshots in 1st pic the cursor is refreshing , in 2nd pic it is stable in 3rd pic it is again refreshing .

[Updated on: Sun, 29 December 2013 12:41]

Report message to a moderator

Re: timer related problem /form cursor keep refreshing [message #604376 is a reply to message #604374] Sun, 29 December 2013 13:03 Go to previous messageGo to next message
mughals_king
Messages: 351
Registered: January 2012
Location: pakistan
Senior Member
Yes brother that's what i had sent this .Fmb file to my friend who is residing in Denmark who is working one of the largest reputed software house in Denamrk finally he just gave me the result that .FMB file is working fine 100% So it seems problem in your specific machine, forms 10g which is working very slow while navigating b'coz same version of form i am also using & i am not facing any problem while navigating But still i am not sure & why it is happening thats why i also sent this request to Sir @littlefoot also b'coz he is Guru & also great man who is having great knowledge so wait & see, may be problem could come in .fmb i also would like to know for my knowledge.



Regard
Mughal


Re: timer related problem /form cursor keep refreshing [message #604377 is a reply to message #604376] Sun, 29 December 2013 13:49 Go to previous messageGo to next message
Littlefoot
Messages: 19305
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As of a PM I received from Mughal: I don't have access to any Forms installation at the moment so I can't test anything, even if I wanted to. So, there are 2 people saying that it works OK and one who says that it doesn't.
  • Did you compare your Forms versions?
  • What happens when you, jgjeetu, deploy that form to web and run it from the application server (as it seems that from Forms Developer it won't work)?
  • Did you try to recompile the form (Ctrl + Shift + K)? Any improvement?
Re: timer related problem /form cursor keep refreshing [message #604378 is a reply to message #604377] Sun, 29 December 2013 14:40 Go to previous messageGo to next message
mughals_king
Messages: 351
Registered: January 2012
Location: pakistan
Senior Member
great Suggestion by Sir @littlefoot So @jgjeetu please follow this and let me know.


Regard
Mughal

[Updated on: Sun, 29 December 2013 14:40]

Report message to a moderator

Re: timer related problem /form cursor keep refreshing [message #604418 is a reply to message #604377] Mon, 30 December 2013 07:43 Go to previous messageGo to next message
jgjeetu
Messages: 203
Registered: July 2013
Location: India
Senior Member
@Littlefoot Sir , Your suggestion did'nt work for me Sad
Re: timer related problem /form cursor keep refreshing [message #604419 is a reply to message #604378] Mon, 30 December 2013 07:45 Go to previous messageGo to next message
jgjeetu
Messages: 203
Registered: July 2013
Location: India
Senior Member
@Mughal bro please make me understand this coding:-
WHEN-TIMER-EXPIRED------TRIGGER

DECLARE 
ExpTimer VARCHAR2(40) := Get_Application_Property(TIMER_NAME); 
vTime VARCHAR2(30):= :SYSTEM.CURRENT_DATETIME; 

BEGIN 

IF ExpTimer = 'CURRTIME' THEN 
   Welcome.TIME := SUBSTR(vTime, instr(vTime,' ')+1); 
END IF; 
END;
Re: timer related problem /form cursor keep refreshing [message #604452 is a reply to message #604419] Mon, 30 December 2013 13:50 Go to previous message
mughals_king
Messages: 351
Registered: January 2012
Location: pakistan
Senior Member
Why not brother,

Timers correspond to internal clocks which have a specific time period When the specified duration expires the timer can either perform an action once and stop or repeat the action regularly every time the timer expires timer duration is always in milliseconds timers are created using the CREATE_TIMER built in and require a WHEN-TIMER-EXPIRED trigger to be written at the form level this trigger fires every time the timer expires.

as we created a display item "CURRENT_TIME" in your case "Time" This item shows the time in HH24:MI:SS format and updates itself every second the timer duration
In the WHEN-NEW-FORM-INSTANCE trigger created a timer named CURRTIME which iterates after every one second and populates the CURRENT_TIME / TIME item with the system date in HH24:MI:SS format the code is as i already posted.

Hope you got something.




Regard
Mughal

[Updated on: Mon, 30 December 2013 13:59]

Report message to a moderator

Previous Topic: query multiple rows from one
Next Topic: Generate Character mode txt reports in runtime
Goto Forum:
  


Current Time: Thu Jul 24 15:17:10 CDT 2014

Total time taken to generate the page: 0.06037 seconds