FbException: arithmetic exception, numeric overflow, or string truncation
-------------------------------------------------------------------------
Key: DNET-377
URL: http://tracker.firebirdsql.org/browse/DNET-377
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 2.6
Environment: Win7 64-bit (using FB 32-bit embedded client)
Reporter: Richard Brown
Assignee: Jiri Cincura
Attachments: DNET-377.zip
Reusing a command+parameters, with different (length) values, causes exception:
FirebirdSql.Data.FirebirdClient.FbException: arithmetic exception, numeric
overflow, or string truncation
Example code:
cmd.CommandText = @"insert into FbTest (Id, TestColumn) values
(@p0, @p1);";
IDataParameter p0 = cmd.CreateParameter();
p0.ParameterName = "@p0";
p0.DbType = DbType.Int32;
p0.Direction = ParameterDirection.Input;
cmd.Parameters.Add(p0);
IDataParameter p1 = cmd.CreateParameter();
p1.ParameterName = "@p1";
p1.DbType = DbType.String;
p1.Direction = ParameterDirection.Input;
cmd.Parameters.Add(p1);
p0.Value = 1;
p1.Value = "test1";
cmd.ExecuteNonQuery();
p0.Value = 2;
p1.Value = "test10";
cmd.ExecuteNonQuery(); // causes exception
Works OK if you revert to 2.5.2 provider.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself;
WebMatrix provides all the features you need to develop and
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
