>>>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.htmlAll irrelevant. What is happening between sql server and vfp6 is the point under consideration.