Q
qlw
Unregistered / Unconfirmed
GUEST, unregistred user!
很奇怪
我在interbase表中建了个存储过程
CREATE PROCEDURE FIND_NAME (
INPUT_VALUE INTEGER
) RETURNS (
OUTPUT_VALUE VARCHAR(20)
) AS
begin
for
select name
from codeHA
where code<:input_value
into utput_value
do suspend;
end
然后调用,我就在BDE EXPLORER中输SQL:
select * from find_name
where
input_value=20
报错说参数不匹配,怎么办?(实际上,
我以前曾试验成功过,但时间一长,忘掉了)
我在interbase表中建了个存储过程
CREATE PROCEDURE FIND_NAME (
INPUT_VALUE INTEGER
) RETURNS (
OUTPUT_VALUE VARCHAR(20)
) AS
begin
for
select name
from codeHA
where code<:input_value
into utput_value
do suspend;
end
然后调用,我就在BDE EXPLORER中输SQL:
select * from find_name
where
input_value=20
报错说参数不匹配,怎么办?(实际上,
我以前曾试验成功过,但时间一长,忘掉了)