Try..Catch vs On Error ???

[Ralph]

Hello everyone.

How is the function below accomplished in vb.net?

*************************
private function test

on error goto here

for i =0 to x
do something
do some more
do last bit
next

exit function

here:
if the error is this then
resume next 'jump back into the for/next loop
endif

end function
*************************

[Jos]

Ralph wrote:

Hello everyone.

How is the function below accomplished in vb.net?

*************************
private function test

on error goto here

for i =0 to x
do something
do some more
do last bit
next

exit function

here:
if the error is this then
resume next 'jump back into the for/next loop
endif

end function
*************************

*************************
private function test

for i =0 to x
do some things that can't go wrong
Try
do something that can go wrong
do some more
do last bit
Catch ex As Exception
' you may also use a more particular Exception object
' e.g. OleDbException
handle the error
Finally
clean up
End Try
next

end function
*************************

--

Jos

[Ralph]

Thanks for the answer Jos.
Simple and sweet code.
I have to make an appointment at the hair restoration clinic after this one.

"Jos" <jo***************@fastmail.fm> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

Ralph wrote:

Hello everyone.

How is the function below accomplished in vb.net?

*************************
private function test

on error goto here

for i =0 to x
do something
do some more
do last bit
next

exit function

here:
if the error is this then
resume next 'jump back into the for/next loop
endif

end function
*************************

*************************
private function test

for i =0 to x
do some things that can't go wrong
Try
do something that can go wrong
do some more
do last bit
Catch ex As Exception
' you may also use a more particular Exception object
' e.g. OleDbException
handle the error
Finally
clean up
End Try
next

end function
*************************

--

Jos

[Herfried K. Wagner [MVP]]

* "Ralph" <Ra***********@theBusStation.net> scripsit:

How is the function below accomplished in vb.net?

*************************
private function test

on error goto here

for i =0 to x
do something
do some more
do last bit
next

exit function

here:
if the error is this then
resume next 'jump back into the for/next loop
endif

You will have to put every statement into a separate 'Try...Catch'
block.

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

[Ralph]

One will work fine. I'm trying to ignore the "duplicate records being added
to a table error" and catch everything else.

Thanks for the input
"Herfried K. Wagner [MVP]" <hi***************@gmx.at> wrote in message
news:uF**************@tk2msftngp13.phx.gbl...

* "Ralph" <Ra***********@theBusStation.net> scripsit:

How is the function below accomplished in vb.net?

*************************
private function test

on error goto here

for i =0 to x
do something
do some more
do last bit
next

exit function

here:
if the error is this then
resume next 'jump back into the for/next loop
endif

You will have to put every statement into a separate 'Try...Catch'
block.

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>