楼上的好象也不行 我写了个简单的存储过程如下 CREATE PROCEDURE aaa @a int, @b varchar(10), @c datetime AS insert into ba(a,b,adate) values(@a,@b,@c) GO程序调用如下 Dim cmd1 As New ADODB.Command Dim a As New ADODB.Parameter Dim b As New ADODB.Parameter Dim c As New ADODB.Parameter
CREATE PROCEDURE aaa
@a int,
@b varchar(10),
@c datetime
AS
insert into ba(a,b,adate)
values(@a,@b,@c)
GO程序调用如下
Dim cmd1 As New ADODB.Command
Dim a As New ADODB.Parameter
Dim b As New ADODB.Parameter
Dim c As New ADODB.Parameter
cmd1.ActiveConnection = cn
cmd1.CommandText = "aaa"
cmd1.CommandType = adCmdStoredProca.Type = adInteger
a.Size = 4
cmd1.Parameters.Append ab.Type = adVarChar
b.Size = 10
cmd1.Parameters.Append bc.Type = adDate
c.Size = 8
cmd1.Parameters.Append c
a.Value = 79
b.Value = Text2.Text
c.Value = Text3.Textcmd1.Execute但是仍然出错