ASP not getting return value

I have a stored procedure like this:



The update statement could violate a primary key constraint, so I need the return value to know that in my ASP code.
When the update succeeds, I do get 0 as the return value, but if it fails, I get nothing.
Running from Query Analizer, everything works fine, so it must be something in my ASP code.

I even tried putting a "Return 1" right after the update, and still I got nothing. It seems that when the update fails, the stored procedure stops executing.

Anyone knows what could be happening?


DarkRodro
PD: Instead of the return value, my idea was to use the error collection, but I had similar outcomes: raiserror never got called.

I'm not understanding the problem?
If it returns 0 when it succeeds, then just check to see if the value returned is equal to 0.
If it isn't then throw an error because it failed.

I posted a simplified example, in that case, like you said, I could check <>0... but I usually have more than one statement in my transactions, so I need different return codes to know WHERE it failed. Also, the same statement could fail for different reasons.