Home » Developer & Programmer » Forms » How can I cancell query at run time
How can I cancell query at run time [message #255502] Wed, 01 August 2007 01:29 Go to next message
Ora_ardor
Messages: 9
Registered: March 2006
Location: PAKISAN
Junior Member

Hi,

I just want to cancel an exeuted query at runtime possibel if yes than how can any body guide me
Regars
Re: How can I cancell query at run time [message #255507 is a reply to message #255502] Wed, 01 August 2007 01:44 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
All you have to do is issue ROLLBACK statement. Use one of the following according to your requirement.

CLEAR_FORM(ask_commit, to_savepoint);
NEW_FORM('my_form', no_rollback);
EXIT_FORM(ask_commit, full_rollback);
Re: How can I cancell query at run time [message #256059 is a reply to message #255502] Thu, 02 August 2007 21:05 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
More information concerning the problem is always helpful. Let me guess, you run a query and it is taking more than 5 minutes to return and you want some way to kill it? Am I correct?

Please specify operating system and version of Forms that you are using.

David
Re: How can I cancell query at run time [message #256078 is a reply to message #256059] Thu, 02 August 2007 23:09 Go to previous messageGo to next message
Ora_ardor
Messages: 9
Registered: March 2006
Location: PAKISAN
Junior Member

Hi,

Your guess is very correct . My form ver is 6i and os is winXP.
please give me all hints to control this situation.


Regards
Asif
Re: How can I cancell query at run time [message #256577 is a reply to message #256078] Mon, 06 August 2007 01:20 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Go to Forms 9 where there is a facility (Ctrl-j? like in TOAD) which typically will stop an executing query. Remember, Forms is a BLOCK mode interface, the front-end can only interact with the back-end when the back-end is willing to listen.

Alternatively, get the DBA to kill the background process or just crash out of your Forms session and start again.

David
Previous Topic: version information of forms ,reports and pl/sql
Next Topic: record grouping populating problem
Goto Forum:
  


Current Time: Sun Dec 04 12:24:03 CST 2016

Total time taken to generate the page: 0.14879 seconds