Hello:
this.cmdUpdate.CommandText = "UPDATE CLIENTES SET CLI_NOME=?, CLI_SOBRENOME=?, VED_COD=? WHERE CLI_COD = ?"; this.cmdUpdate.Parameters.Add(new FirebirdSql.Data.Firebird.FbParameter ("CLI_NOME", FirebirdSql.Data.Firebird.FbDbType.VarChar, 40, "CLI_NOME")); this.cmdUpdate.Parameters.Add(new FirebirdSql.Data.Firebird.FbParameter("CLI_SOBRENOME", FirebirdSql.Data.Firebird.FbDbType.VarChar , 40, "CLI_SOBRENOME")); this.cmdUpdate.Parameters.Add(new FirebirdSql.Data.Firebird.FbParameter("CLI_COD", FirebirdSql.Data.Firebird.FbDbType.Integer, 0, System.Data.ParameterDirection.Input , false, ((byte)(0)), ((byte)(0)), "CLI_COD", System.Data.DataRowVersion.Current, null)); this.cmdUpdate.Parameters.Add(new FirebirdSql.Data.Firebird.FbParameter("VED_COD", FirebirdSql.Data.Firebird.FbDbType.Integer , 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "VED_COD", System.Data.DataRowVersion.Current, null));
If you use the placeholder for parameters ( ? ) you should define the parameters in the same order as they appear in the sql command text.
-- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ "When you don't code, you tend to become one of those architects who thinks everything is possible" ( Anders Hejlsberg ) ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
