急!求救,存储过程出错!
建一表如下:
CREATE TABLE [dbo].[Ztest] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[price] [numeric](9, 2) NULL ,
[cost] [numeric](9, 2) NULL
) ON [PRIMARY]
GO
建一存储过程如下:
CREATE PROCEDURE SP_Ztest_ADD
@price nvarchar(50),
@cost nvarchar(50)
AS
insert into Ztest(price,cost) values(@price,@cost)
GO
VB高调用存储过程程序如下:
Dim cmd As New ADODB.Command
cmd.ActiveConnection = G_Con
cmd.CommandType = adCmdStoredProc
cmd.CommandText = "SP_Ztest_ADD"
cmd.Parameters.Append cmd.CreateParameter("@price", adNumeric, adParamInput, 5, Trim(Text1.Text))
cmd.Parameters.Append cmd.CreateParameter("@cost", adNumeric, adParamInput, 5, Trim(Text2.Text))
运行出错:The Precision is invalid,
请问各位大侠,如何解决???