Ilianam
asked on
What I'm doing wrong
I Know it's stupid but please take a look
in vb.net
With myCommand2
.Parameters.Add("@Examiner
.Parameters("@Examiner").V
.executeNonquery()
End With
and my sp
ALTER procedure spMDDeleteExaminer
@Examiner integer
as
UPDATE [CorpDataTest].[dbo].[MDCl
SET [sActiveInactiveInd]='I'
WHERE lUserId=@Examiner
return
When I execute it, vb.net says that there is an error in my sp
SOS....I cann't see it
in vb.net
With myCommand2
.Parameters.Add("@Examiner
.Parameters("@Examiner").V
.executeNonquery()
End With
and my sp
ALTER procedure spMDDeleteExaminer
@Examiner integer
as
UPDATE [CorpDataTest].[dbo].[MDCl
SET [sActiveInactiveInd]='I'
WHERE lUserId=@Examiner
return
When I execute it, vb.net says that there is an error in my sp
SOS....I cann't see it
ASKER CERTIFIED SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
it would certainly help to see the error message
but you say that SqlDbType is a varchar and the sp is expecting a integer, but not sure if thats the problem
hope this helps a bit
bruintje