Query based update failed

Hi,

I have a program that works as a back end process ( a trigger program). The problem is, when it is running, most of the time, it will prompt the error,

"Query based update failed because row to update could not be found"

I have tried running the program line by line, but the error just doesn't come out. Please help.

Thanks

Hi,

Could you give a bit more details? Eventually show the code.

Regards,
Shurik.

put proper error handling in your code that logs errors to a log file rather than to the screen.

Hello kliklu

I think theres a problem with UPDATE SQL statememt.

First, you should find out the problem of your SQL statement in SQL Server Quary Analyzer by Running statement. (You can find your error in UPDATE or TRIGGER statement)

If it's work, check you code and then you permission to SQL Stored procedure.

Yours :cool: