>>>>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.