StoredProcedure Error
I have a system that connects to a MariaDB database on a local server, I have installed the same database on a client's server and it is giving me illogical errors, I will post an example below. using (MySqlConnection conn = new MySqlConnection(BdConnection.ConnectionString)) { conn.Open(); MySqlCommand cmd = new MySqlCommand("NewMovement", conn); cmd.CommandType = CommandType.StoredProcedure; MySqlParameter ReturnValue = new MySqlParameter("Value", SqlDbType.Int); ReturnValue.Direction = ParameterDirection.Output; cmd.Parameters.Add(ReturnValue); cmd.Parameters.AddWithValue("p_IdAlmSale", IdAlmSale); cmd.Parameters.AddWithValue("p_IdAlmEntra", IdAlmEntra); cmd.Parameters.AddWithValue("p_NomMovSale", NomMovSale); cmd.Parameters.AddWithValue("p_NomMovEntra", NomMovEntra); cmd.Parameters.AddWithValue("p_CostMov", CostMov); cmd.Parameters.AddWithValue("p_Observations", Obs); cmd.Parameters.AddWithValue("p_IdUsu", Util.UsuActual.id); cmd.Parameters.AddWithValue("p_UsuarioRealiza", Util.UsuActual.nombre); int rowsAffected = cmd.ExecuteNonQuery(); if (rowsAffected > 0) { Result.Id = Convert.ToInt32(cmd.Parameters["Value"].Value); } conn.Close(); conn.Dispose(); }
The error I get is the following... 'Incorrect decimal value: 'Initial Inventory' for column ``.``.`p_MoveCost` at row 1'
I have noticed that the value I receive in a parameter is receiving it in the next parameter,
How can I solve this error, it is only happening on the client's server, on my local server it works without problems