Recent content by Richard6

Thanks, that did the trick. Now the data is all getting passed into the parameters properly but I am getting another error on execution: "Invalid Character Value for Cast Specification." Can anyone give me any help on this one?

Thanks. I've added that to the code but am still getting "the Precision is invalid". I am assuming that it is to do with the DECIMAL field because there are only int fields apart from this (relating to numbers). I have also tried changing the PRECISION value on the SQL server to 4, 2 and 0 but...

Hello, I have the following code to update a SQL Server 2005 table via a Stored Procedure called spUpdate. One of the parameters is bring back a PRECISION error and I assume it is the field set to a DECIMAL type on the server (Payment). The table is set to DECIMAL with a scale of 2 and the...