>>>>Where you read this?
>>>>I use SP rarely and i am not aware of this?
>>>>Just remove this block from my example and try it w/o error handling.
>>>
>>>I meant to say that when you call a SP via Ole DB you can't use TRY/CATCH syntax. This is what one of guys from VFPT confirmed here. It would be great to be able to use TRY/CATCH in SP from Ole DB.
>>
>>If you have other copies of the database somewhere, can you check them as well. There is a possibility that the wrong table was updated.
>
>I tried that already. No other database/table is updated.
Ok. I think we're not yet sure, if SP works from VFP or not.
In other words, is the problem only from calling it from .NET or it's not working at all?
Could the problem be in VFP environment settings?
If it's not broken, fix it until it is.
My Blog