在线求帮忙...delphi调用存储过程参数问题
delphi初学者:求指教!
下面是我在delphi里面写的代码:
F_StoredProc := TADOStoredProc.Create(nil);
with F_StoredProc do
begin
Connection := F_Connection;
ProcedureName := 'ProcUserLogin';
Parameters.Clear;
================一运行就报错...不知道为什么=============================
Parameters.CreateParameter('@name',ftString,pdInput,20,edit1.text);
Parameters.CreateParameter('@pwd',ftString,pdInput,20,edit2.text);
================用下面的这种方法也报错,说参数不成立======================
//Parameters.ParamByName('@name').Value := edit1.Text;
//Parameters.ParamByName('@pwd').Value := edit2.Text;
Prepared := true;
Open;
end;
===================这是我的存储过程=============
CREATE PROCEDURE ProcUserLogin
@name varchar(20),
@pwd varchar(20)
AS
select COUNT(*) from UserLogin where (UName=@name) and (UPwd =@pwd )
GO