SQL SERVER 7.0 中storeprocedure 的RETURN VALUE 如何使用(100分)

W

wuhao

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-03-29

• #1

I have SQL server 7.0 storeprocedure like this :
create proc XXXXX ... as
if (condition) return(0)
else return(3)
when I use it in delphi 4 storeprocedure,the return value is always 0 not 3 even if it should return 3.I test in in SQl
query analyzer the SQL statement is ok.can you help me?

 

F

fx

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-03-29

• #2

return 0 means the storeprocedure executes without errors.
You must declare a output variant to ruturn value.like this:
create proc XXX @result int output
as
if (condition) select @result=0
else select @result=3

when you run the storeprocedure,write like this:
declare @a int
exec XXX @result=@a output
select @a

 

王

王刚

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-03-29

• #3

把括号去掉看行不行.

 

W

wuhao

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-03-31

• #4

This is solution way,I want to know how can I get SQL server 7.0 storeprocedure return value using result type variant in delphi 4.0 storeprocedure without declare output param in SQL server storeprocedure

 

S

SeaSky

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-04-05

• #5

例子:
var i:integer;
with query1 do begin
SQL.TEXT:='EXECUTE PROC1 :INPUTParam :OUTPUTParam';
ParamByname('INPUTParam').Asstring:='AC0022';
ParamByname('OUTPUTParam').DataType:=ftInteger;
ParamByname('OUTPUTParam').ParamType:=ftOutput;
ExecSQL;
i:=ParamByname('OUTPUTParam').value;
end
case i of
3 : {do something};
5 : {do something};
else
{do something};
end;

 

C

CJ

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-04-05

• #6

You could use the property of TQuery called Params

 

T

tangyin

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-04-09

• #7

干脆你在storedproc里raiserror算了。

 

王

王寒松

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-06-09

• #8

同意FX的看法，别人的说法都没有切中要害
关键是 MS SQL SERVER 的自定义返回值该为一变量
而不是常量
所以 return 0 不会成功
declare 一个变量
select 该变量=0
再 return 此变量即可

 

C

CJ

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-06-30

• #9

请继续讨论或结束问题！

 

C

CJ

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-07-06

• #10

不想结束要申请！