>>>>>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.
Can't use filetostr() in OLE DB ST :(
"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