-
Updating errors
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('UnPass Ordgrp Fail',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's values is not found? Please help!!!
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|