>>I am guessing sql is handling the error and vfp 6 does not seem to like the throw or raiserror so much.
>
>OK, I could be completely wrong, but.....I thought TRY...CATCH came out in SQL 2005. RAISERROR probably goes back further to SQL 2000 (I think?).
>
>I can't recall if THROW was in SQL 2005 or if it was added later.
>
>VFP 6 was....1998?
>
>Again, wild guess.
THROW was added in 2012 and TRY/CATCH, I believe, in SQL Server 2008. The article in TechNet WiKi I think was a good write-up at that time (I think it was written in 2013). Of course, for a very long and super detailed and great information one needs to read Erland's article on that subject.
http://www.sommarskog.se/error_handling/Part1.html
If it's not broken, fix it until it is.
My Blog