David,

You have a lot more bit parameters than you are passing.


>SQLEXEC(gnConnhandle,[exec spUpdateValidObr 'Negative','05/05/2006','7298','6831',1,1,1,1,1,'Its Alive!!!!!','Harvey','James','LT','Admin Services','B','Garrett','Don','Major',2 ])
>
>
>

>CREATE PROC spUpdateValidObr
>
>@ObrType varchar(8) = '',
>@ObrDate datetime = '',
>@SuperIbm char(10) = '',
>@OfficerIbm char(10) = '',
>@Appearance bit = '',
>@Attitude bit = '',
>@Communication bit = '',
>@Compatibility bit = '',
>@JobKnowledge bit = '',

-- these are missing:

>@Judgement bit = '',
>@Productivity bit = '',
>@Receptiveness bit = '',
>@PublicDealing bit = '',
>@Reliability bit = '',
>@UseOfEquipment bit = '',


>@Narrative char(2500) = '',
>@OfficerLastName char(25) = '',
>@OfficerFirstName char(20) = '',
>@OfficerRank varchar(30) = '',
>@Precinct char(30) = '',
>@Shift char(1) = '',
>@SuperLastName char(25) = '',
>@SuperFirstName char(20) = '',
>@SuperRank varchar(30) = '',
>@lnID INT
>