sql存储过程返回值与RAISE
有一个存储过程:
CREATE proc aa(@flag int)
as
if @flag=1
begin
raiserror('flag is 1',16,1)
return 1
end
else
begin
raiserror('flag is 0',16,1)
return 0
end
DELPHI程序如下:
procedure TForm1.Button1Click(Sender: TObject);
var s: char;
Re:integer;
begin
try
ADOStoredProc1.Parameters.ParamByName('@flag').Value:=1;
ADOStoredProc1.ExecProc;
re:=adostoredproc1.Parameters.ParamByName('@RETURN_VALUE').Value;
//showmessage(re);
// showmessage(adostoredproc1.Parameters.ParamValues['@Return_Value']);
except
on e:exception do showmessage(e.Message);
end;
showmessage(inttostr(re));
end;
返回值使终都是0,好像都没有执行RETURN这一句?