>>>>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.
Here is how I test such problems. After each command I add a line into some text file using filetostr function.
E.g.
use myTable ...
filetostr("Table myTable is now used", "ProblemSP.txt",1)
append blank
filetostr("Record is supposed to be appended to myTable", "ProblemSP.txt",1)
etc.
If it's not broken, fix it until it is.
My Blog