Home » SQL & PL/SQL » SQL & PL/SQL » Exit from query_mode
Exit from query_mode [message #10768] Mon, 16 February 2004 18:09 Go to next message
Hansmukh Ukawat
Messages: 1
Registered: February 2004
Junior Member
Dear Sir,

Let me know how to Exit from Query Mode in Form without press

Ctrl+Q.

Thanks

Report message to a moderator

Re: Exit from query_mode [message #10773 is a reply to message #10768] Tue, 17 February 2004 00:40 Go to previous message
Riaz
Messages: 112
Registered: February 2002
Senior Member
Use abort_query built-in under when button pressed trigger. But if there is no open query to close then ABORT_QUERY is ignored. To programmatically cancel Enter Query mode, call the built-in EXIT_FORM, using a When-button-pressed trigger to check a flag as follows:

IF :system.mode = 'ENTER-QUERY')
THEN
abort_query;
END IF;

---hope this will work fine

Report message to a moderator

Previous Topic: re-ordering lines in an order table
Next Topic: In a Trigger to get "ConditionColumn" and "ConditionValue" what is the way?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 06:09:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.