loop [message #83980] |
Tue, 13 January 2004 02:42 |
Developer
Messages: 19 Registered: January 2004
|
Junior Member |
|
|
Hi!
I m using a loop in form, which inserts 1 million records in a table by pressing a button.
sometime i press the button by mistake.
Is there ant way to stop the loop after it starts.
regards
|
|
|
Re: loop [message #83982 is a reply to message #83980] |
Tue, 13 January 2004 17:59 |
Zain
Messages: 30 Registered: October 2003
|
Member |
|
|
No. A better approach would be to write an alert on the button so that it warns you when you press it.
|
|
|
Re: loop [message #83987 is a reply to message #83982] |
Wed, 14 January 2004 02:36 |
Syed Ferhat
Messages: 20 Registered: January 2004
|
Junior Member |
|
|
Dear Developer,
Once you press the button , the trigger fired right away and control goes out from user level, so their is no hope except one, if the process take minute or more then you will press CTRL+ALT+DEL as quick as you can before complition of the process and select end task .
There is no change in your table because the commit is not executed.
Hope you will find it better , and if you find any other solution also send me.
Thanks
Ferhat
|
|
|
|
Re: loop [message #83990 is a reply to message #83980] |
Wed, 14 January 2004 05:33 |
magnetic
Messages: 324 Registered: January 2003
|
Senior Member |
|
|
the best solution is to kill the session.
there for you need the "kill session" privilege
|
|
|
Re: loop [message #84038 is a reply to message #83988] |
Tue, 20 January 2004 23:53 |
Syed Ferhat
Messages: 20 Registered: January 2004
|
Junior Member |
|
|
Dear Zain,
Hello again yes its is possible to stop the loop while processing although that is not a professional approach but i have the same solution so plz tell me if u get some other. I already have experience with the same
Thanks
|
|
|