OraFAQ Forum: Forms » cancel query.............

Home » Developer & Programmer » Forms » cancel query.............

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

cancel query............. [message #197190]

Tue, 10 October 2006 08:01

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...

Report message to a moderator

Re: cancel query............. [message #197252 is a reply to message #197190]

Tue, 10 October 2006 14:35

Littlefoot
Messages: 21823
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;

Report message to a moderator

Re: cancel query............. [message #197305 is a reply to message #197190]

Tue, 10 October 2006 22:54

shahidmughal
Messages: 91
Registered: January 2006
Location: Faisalabad Pakistan

Member

hi
use abort_query built in for canceling the query
regards
Muhammad Shahid Mughal

Report message to a moderator

Re: cancel query............. [message #197307 is a reply to message #197252]

Tue, 10 October 2006 22:58

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

Report message to a moderator

Re: cancel query............. [message #198002 is a reply to message #197190]

Fri, 13 October 2006 13:52

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

Report message to a moderator

Re: cancel query............. [message #198007 is a reply to message #198002]

Fri, 13 October 2006 15:04

Littlefoot
Messages: 21823
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).

Report message to a moderator

Previous Topic:	When_validate_trigger
Next Topic:	Call report from a form - hits Invalid parameter Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 09 17:03:18 CDT 2025