Good day all, I would like to ask a thing about on error resume next

let's assume we have a loop to navigate through a recordset like:

Do while not rs.EOF
query = "UPDATE ...."    
conn.execute(query)    
rs.movenext
loop

i would like to be sure the UPDATE is going good, and i would like to check if there is some problems, so I have put a debugging features in the code like:

Do while not rs.EOF
query = "UPDATE ...."

on error resume next

conn.execute(query) 

If Err.Number <> 0 Then
   Response.write(Err.Number)
   response.write("<br>")
   response.write(Err.description)
   response.write("<br>")
   response.write(query)
   response.write("<br><br>")
end if

on error goto 0

rs.movenext
loop

the question is : during a loop, if it encounters an error, the next cycle will the error be there (and so triggers again the error block) ? or on error goto 0 will clear the Err object? in other words, will it works as a error handling?

asp-classic vbscript error-handling
Edit
Report