2011 Aug 23 6:53 PM
Hi friends!!
I have a problem in my program. Sometimes, depending of server I have a timeout dump in a Loop process. Its possible avoid this using try/catch and show to user message instead?
Thanks for any help.
Edited by: Fulvio Valente on Aug 23, 2011 7:53 PM
2011 Aug 23 7:16 PM
Hi
try/catch for what?
If you don't have any updating of tables of database you can call a COMMIT WORK, this comand will reset the time
But you should understand why your loop takes so long
Max
Other way to think to stop time out dump...
Please try to run the program in background
OR
Please divide the bigger loop with where clause
Thanks.
2011 Aug 23 7:16 PM
Hi
try/catch for what?
If you don't have any updating of tables of database you can call a COMMIT WORK, this comand will reset the time
But you should understand why your loop takes so long
Max
2011 Aug 23 7:46 PM
I thinking a way to avoid dump screen for user...but timeout has no exception...
Loop takes so long 'cause large data in some cases...
2011 Aug 23 8:11 PM
Hi,
Time out is a non-catchable exception (by the way there are many non-catchable exceptions), so you can't catch it (to say the truth there's one way to handle them but it's very complex and not desirable anyway).
Sandra
2011 Aug 23 8:12 PM
Other way to think to stop time out dump...
Please try to run the program in background
OR
Please divide the bigger loop with where clause
Thanks.
2011 Aug 23 8:33 PM
Thanks for replies friends.
I will try a more limited data selection instead.
Regards!
| User | Count |
|---|---|
| 6 | |
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |