Mark Shvarts (6/5/2008)
I tried to reproduce your code, but it complains about (@stmt), apparently you did not test this code prior to posting.But my point anyway is that Catch block cannot actually catch all the errors (unless I am doing something fundamentally wrong). If I am correct, using Try/Catch can be even misleading, like in my case it did not report any errors but the file was not loaded either.
Didn't test what? It's a copy-and-paste of your proc with one minor change. I've tested that change, by using it hundreds of times in the last 7 years.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon