I am trying to update a table in 6.5. There is a parameter to a field of a value I know does not exist. So when updating I should get an error. Here is my example:

CREATE PROCEDURE Update_UnProd_Ordgrp_SP @grp_label Char(6)
AS
UPDATE Ordgrp
Set grp_prdflg = 0
WHERE
grp_label = @grp_label

if @@ERROR <>0
BEGIN
RAISERROR(&#39;UnPass Ordgrp Fail&#39;,18,1)
RETURN 99
END

but when I try to read this from VB (using adParamReturnValue),
is says my error value is 0. Is there something I am doing wrong? Does SQL server give an error if one of the paramter&#39;s values is not found? Please help!!!

Thanks