Thank you for your input. Unfortunately they (VFPT) forgot to enable this wonderful feature in Ole Db Provider.
>FYI, TRY/CATCH Blocks were included since VFP 8.0.
>
>
>>I am looking at the list of the Unsupported commands in VFP9 Ole Db Provider and TRY...ENDTRY is not there.
>>>
>>>However, when I call a Stored Procedure via Ole Db Provider (Visual FoxPro 9), the procedure does not execute. I put some test code in the stored procedure and it looks like everything before TRY works but after does not.
>>>
>>>Any suggestions, please?
>>
>>No, TRY...ENDTRY is not supported by Visual FoxPro OLE DB provider.
>
>>It was not fair for me to ask you why VFPT does this or that.
>
>>Thank you for your help. It is too bad TRY .. ENDTRY is not supported, it is my favorite addition to Visual FoxPro 9 (Since Visual FoxPro 6)
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham