It was this simple, cant belive how dumb i am omg
It solved my problems, thanx a lot.
On 5/5/06, Carlos Guzmán Álvarez
<[EMAIL PROTECTED]> wrote:
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
