Home » Developer & Programmer » Forms » Enter Query !!!
Enter Query !!! [message #80704] Tue, 05 November 2002 00:52 Go to next message
Qavi
Messages: 24
Registered: August 2002
Junior Member
Hello Experts !

i have a block which is running in enter-query mode and control block in which i have placed EXIT button ... when ever i run the form it will be in ENTER-QUERY mode and if i want to exit the form without executing it will not allow until i perform execute query .. i coded EXIT_FORM(NO_VALIDATE) IN EXIT BUTTON ..... any suggestion to overcome this problem ..
Rgds
Qavi
Re: Enter Query !!! [message #80706 is a reply to message #80704] Tue, 05 November 2002 09:44 Go to previous message
Julie
Messages: 98
Registered: February 2002
Member
To programmatically cancel Enter Query mode, call the built-in EXIT_FORM, using a When-New-Record-Instance trigger to check a flag as follows:

IF (:global.cancel_query = 'Y'
and :system.mode = 'ENTER-QUERY')
THEN
Exit_Form;
:global.cancel_query = 'N';
END IF;
Previous Topic: Forms4.5/Reports 2.5 on Windows 2000 with Oracle 9i
Next Topic: Opening a file -- Urgent
Goto Forum:
  


Current Time: Sat May 18 15:38:27 CDT 2024