This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-01. For the latest, interactive version please visit https://mariadb.com/kb/.

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

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.