Search results

  1. R

    Precision Error

    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?
  2. R

    Precision Error

    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...
  3. R

    Precision Error

    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...
Back
Top Bottom