Home » Developer & Programmer » Forms » cancel query.............
icon7.gif  cancel query............. [message #197190] Tue, 10 October 2006 08:01 Go to next message
imtiazmasud
Messages: 49
Registered: May 2005
Location: Bangladesh
Member


Hi all,
I have a tool bar and there is three separate button for enter query,execute query and cancel query and many other customize button for customized works..

now for enter query mode we write ENTER_QUERY
to execute query we write EXECUTE_QUERY then
what is for cancel query ??

N.B : alternatively we can do it by ctrl+q but if there is any built in command like enter and execute query...
Re: cancel query............. [message #197252 is a reply to message #197190] Tue, 10 October 2006 14:35 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Put this code into the WHEN-BUTTON-PRESSED trigger:
IF :SYSTEM.MODE = 'ENTER-QUERY' 
   THEN
   EXIT_FORM(NO_VALIDATE);
END IF;
Re: cancel query............. [message #197305 is a reply to message #197190] Tue, 10 October 2006 22:54 Go to previous messageGo to next message
shahidmughal
Messages: 91
Registered: January 2006
Location: Faisalabad Pakistan
Member

hi
use abort_query built in for canceling the query
regards
Muhammad Shahid Mughal
Re: cancel query............. [message #197307 is a reply to message #197252] Tue, 10 October 2006 22:58 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Hi,

check there are three modes in which your form opens up .

bye
icon6.gif  Re: cancel query............. [message #198002 is a reply to message #197190] Fri, 13 October 2006 13:52 Go to previous messageGo to next message
imtiazmasud
Messages: 49
Registered: May 2005
Location: Bangladesh
Member

Hi all,
Thanks a lot to reply... but its not working at all
I tried like this............

IF :SYSTEM.MODE = 'ENTER-QUERY' THEN
:SYSTEM.MODE = 'NORMAL';
END IF;

but Its not working......there is a matter of converting the form into NORMAL mode but its not working......please help...................imtiazmasud
Re: cancel query............. [message #198007 is a reply to message #198002] Fri, 13 October 2006 15:04 Go to previous message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
OK, I'm glad you showed some initiative and wrote a code of your own (which didn't work, as you've said), but - curious as I am - I'd just like to know did you manage to cancel a query using my code (here it is again)
IF :SYSTEM.MODE = 'ENTER-QUERY' 
   THEN
   EXIT_FORM(NO_VALIDATE);
END IF;
writing the WHEN-BUTTON-PRESSED trigger on the "Cancel query" button on your form?

Becacuse, I did try it and yes, it did work for me (Forms Developer 10g connected to Oracle 10g).
Previous Topic: When_validate_trigger
Next Topic: Call report from a form - hits Invalid parameter Error
Goto Forum:
  


Current Time: Sat Dec 03 05:52:10 CST 2016

Total time taken to generate the page: 0.28136 seconds