Home » Developer & Programmer » Forms » Why i need to press the push button twice to complete my action? (DB & DEV 10g / Windows 7)
icon5.gif  Why i need to press the push button twice to complete my action? [message #423861] Mon, 28 September 2009 14:16 Go to next message
Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt
Senior Member

in my Push Button at WHEN-BUTTON-PRESSED trigger I wrote this code:

FORMS_DDL('CREATE TABLE DEMO (DEMO_ID NUMBER ENCRYPT USING ''AES256'' NO SALT NULL, DEMO_DATE DATE ENCRYPT USING ''AES256'' NO SALT NOT NULL)');
FORMS_DDL('CREATE UNIQUE INDEX DEMO_PK ON DEMO(DEMO_ID)');
FORMS_DDL('ALTER TABLE DEMO ADD (CONSTRAINT DEMO_PK PRIMARY KEY (DEMO_ID))');	
----
FORMS_DDL('alter system set wallet open identified by "zaq1xsw2"');      
INSERT INTO demo VALUES (84,SYSDATE);      
COMMIT;
FORMS_DDL('ALTER SYSTEM SET WALLET CLOSE');
----
Message('Thanks for buying our program.');      
Message('Thanks for buying our program.');
----
Go_item('DEPT.DEPTNO');      
Replace_content_view('WINDOW1','CANVAS4');


but I need to press in it twice - two times - to execute the code above.

The Question is : why the code doesn't execute from first press ?
Re: Why i need to press the push button twice to complete my action? [message #424567 is a reply to message #423861] Sat, 03 October 2009 20:05 Go to previous messageGo to next message
mustafagamiel
Messages: 17
Registered: April 2009
Location: Egypt
Junior Member

dear : hany

this code execute with me by once press
but
in this line "INSERT INTO demo VALUES (84,SYSDATE); " give me error because this table still not exist in DB
so I change this row by put this line in forms_dll command
so how this exeute with you without error





Re: Why i need to press the push button twice to complete my action? [message #424678 is a reply to message #423861] Mon, 05 October 2009 05:07 Go to previous message
TonyJaa
Messages: 50
Registered: May 2009
Member
Hello,

Check at your button's property make non-navigeable keyboard and mouse. Maybe the first click, put the focus on the button and the second one press it...
Previous Topic: Forms Validation
Next Topic: CLEAR_LIST
Goto Forum:
  


Current Time: Sun Dec 04 02:56:16 CST 2016

Total time taken to generate the page: 0.10475 seconds