ado query 问题
ADOQ->Close();
ADOQ->SQL->Add("EXEC InsertIp :mac,:ip,:pcname");
ADOQ->Parameters->Items[0]->Value="123";
ADOQ->Parameters->Items[1]->Value="1111";
ADOQ->Parameters->Items[2]->Value="1234";
ADOQ->ExecSQL();
当第二次调用时提示不正常地定义参数对象提供了不一致或不完整的信息是怎么回事
存储过程如下CREATE PROCEDURE [InsertIP]
@mac char(12),
@ip char(16),
@pcname char(16)
AS
BEGIN
if(exists(select * from IPList where MacAddr= @mac ))
begin
update IPList
set PCName=@pcname,IPAddr=@ip,RfulshTime=getdate()
where MacAddr=@mac
return 0
end
else
begin
insert into IPList (MacAddr,IPAddr,PCName,rfulshtime)
values(@mac,@ip,@pcname,getdate())
return 1
end
END
GO
mac char[12] ip char [16] pcname char[16]