?
Solved

Cancel Query in Forms

Posted on 2001-08-10
3
Medium Priority
?
1,381 Views
Last Modified: 2007-12-19
what is the procedure behing cancel query. I use enter_query, execute_query for their corresponding purposes but when I use cancel_query it does not work. What should I use to cancel the query.
0
Comment
Question by:aqk139
3 Comments
 
LVL 35

Accepted Solution

by:
Mark Geerlings earned 400 total points
ID: 6372185
Try "exit_form".  Of course, you need to make sure the form is in enter-query mode at the time, otherwise it really will exit the form, and that probably is not what you want.
0
 
LVL 2

Expert Comment

by:santoshmathew
ID: 6372338
Hi,

If you are using Forms 4.5 you can set the environment variable FORMS45_NONBLK=Y in Unix.
For Windows this has to be set in the registry.

After this Cancel_query will show a dialog box when you execute the cancel_query built-in.

Regards.
 
0
 
LVL 4

Expert Comment

by:jtrifts
ID: 6372370
I usually use RAISE FORM_TRIGGER_FAILURE; or simply RETURN;

JT
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question