Avoid timeout dump

[Former Member]

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

[Former Member]

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

[Former Member]

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...

[Sandra_Rossi]

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

[Former Member]

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.

[Former Member]

Thanks for replies friends.

I will try a more limited data selection instead.

Regards!