>>Can you see what is the command you're sending to the SQL Server by using SQL Server profiler?
>>
>>Try creating the variables then for your constant values, e.g.
>>
>>lnNull = null
>>
>>llIs = EditRec.lncSave
>>
>>etc.
>>
>>and pass them using ? syntax.
>
>I should add extras steps to replace something that was working before I removed 3 parameters and started getting the error?
I don't understand your question. What you have right now is incorrect and weird. I suggest to use simple variables for each parameter and pass them using
?m.Var1, ?m.Var2, ?m.Var3, etc.
to your stored procedure. Don't mix complex expressions, constants, etc. in one call.
If it's not broken, fix it until it is.
My Blog