W
wallysw
Unregistered / Unconfirmed
GUEST, unregistred user!
各位,我写了个存带参数的存储过程,为什么调用时出错啊。
存储过程我是这样写的:
---------------------------------------------------------------------
CREATE PROCEDURE dbo.ysws(@fv char) AS
select * from yelong where a=@fv
-----------------------------------------------------------------------
DELPHI里面,我是这样调用的:
-----------------------------------------------------------------------
ADOStoredProc1.ConnectionString := 'Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ysw;Data Source=WJ';
ADOStoredProc1.Close;
ADOStoredProc1.Parameters.Clear;
ADOStoredProc1.ProcedureName := 'ysws';
ADOStoredProc1.Parameters.ParamByName('@fv').value := 'a';
ADOStoredProc1.Parameters.Refresh;
ADOStoredProc1.ExecProc;
-------------------------------------------------------------------------
它老是提示@fv参数没有找到,是怎么回事了,哪里错了啊?望高手指点,小弟不胜感激!
存储过程我是这样写的:
---------------------------------------------------------------------
CREATE PROCEDURE dbo.ysws(@fv char) AS
select * from yelong where a=@fv
-----------------------------------------------------------------------
DELPHI里面,我是这样调用的:
-----------------------------------------------------------------------
ADOStoredProc1.ConnectionString := 'Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ysw;Data Source=WJ';
ADOStoredProc1.Close;
ADOStoredProc1.Parameters.Clear;
ADOStoredProc1.ProcedureName := 'ysws';
ADOStoredProc1.Parameters.ParamByName('@fv').value := 'a';
ADOStoredProc1.Parameters.Refresh;
ADOStoredProc1.ExecProc;
-------------------------------------------------------------------------
它老是提示@fv参数没有找到,是怎么回事了,哪里错了啊?望高手指点,小弟不胜感激!