469,299 Members | 2,069 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,299 developers. It's quick & easy.

how to create running clock in oracle forms 6i

pls. send the proper step by step coding.
Feb 8 '08 #1
4 16157
in new_form_instance on form level
Expand|Select|Wrap|Line Numbers
  1.  
  2. DECLARE 
  3. CurrTime TIMER; 
  4. OneSec CONSTANT NUMBER := 1000; 
  5. BEGIN 
  6. CurrTime := CREATE_TIMER('CURRTIME',OneSec,REPEAT); 
  7. END; 
  8.  
  9.  
  10. in when_timer_expired  on form level
  11.  
  12. DECLARE 
  13. ExpTimer VARCHAR2(40) := Get_Application_Property(TIMER_NAME); 
  14. vTime Varchar2(30) := :SYSTEM.CURRENT_DATETIME; 
  15. BEGIN 
  16.  
  17. IF ExpTimer = 'CURRTIME' THEN 
  18.  
  19. :yourblockname.clock := SUBSTR(vTime, instr(vTime,' ')+1); 
  20.  
  21. END IF; 
  22. END; 
  23.  


hope it will be work

ALI
Feb 27 '08 #2
in new_form_instance on form level

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


in when_timer_expired on form level

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

IF ExpTimer = 'CURRTIME' THEN

:yourblockname.clock := SUBSTR(vTime, instr(vTime,' ')+1);

END IF;
END;



hope it will be work

ALI
Thank you.............................
Feb 27 '08 #3
amitpatel66
2,367 Expert 2GB
Duplicate post by smartali4u is deleted
Feb 29 '08 #4
:yourblockname.clock := SUBSTR(vTime, instr(vTime,' ')+1);

giving an error if I put :yourblock.fieldname
then it works properly
May 28 '10 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Thomas Kindermann | last post: by
reply views Thread by zellipa | last post: by
1 post views Thread by sujan | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Geralt96 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.