hey guys can someone please tell me what im doing wrong.
My sproc is something like this:
Code:
create proc dt_addnewcustomer
@CustIsInactive bit,
@CustFName varchar(100)
SET NOCOUNT ON
AS
insert into tlbcustomers (CustFName, CustIsInactive) VALUES (@CustFname, @CustIsInactive)
go
my vbcode is like this:
VB Code:
dim CustIsInactive as boolean
CustIsInactive = false
Set adocommand = New ADODB.Command
With adocommand
.ActiveConnection = con
.CommandType = adCmdStoredProc
.CommandText = "dt_addnewcustomer"
.Parameters.Append .CreateParameter("@CustFName", adVarChar, adParamInput, 100, Trim(CustFName.Text))
.Parameters.Append .CreateParameter("@CustIsInactive", adboolean, adParamInput, 1, CustIsInactive)
.Execute , , adCmdStoredProc + adExecuteNoRecords
Set adocommand = Nothing
end with
I really dont see what im doing wrong, and it's driving me nuts!! Someone please help