Please do not reply to this email- if you want to comment on the bug, go to the URL shown below and enter your comments there.
Changed by [EMAIL PROTECTED] http://bugzilla.ximian.com/show_bug.cgi?id=81916 --- shadow/81916 2007-07-23 07:38:53.000000000 -0400 +++ shadow/81916.tmp.15213 2007-07-23 09:49:47.000000000 -0400 @@ -60,6 +60,33 @@ * Without "Prepare()" exec sp_executesql N'SELECT aeCodPessoa, aeMatFunc, aeCracha, aeCodPonto FROM vwAcessosEmpregados ORDER BY aeCodPonto, aeMatFunc' ------- Additional Comments From [EMAIL PROTECTED] 2007-07-23 07:38 ------- Can you please attach a test case to reproduce this issue ? + +------- Additional Comments From [EMAIL PROTECTED] 2007-07-23 09:49 ------- +The code I use is generated by a Data Layer Class, I have generated +a similar: + +parametroProcedure = ConexaoFactory.CreateParameter() +parametroProcedure.DbType = DbType.Int32 +parametroProcedure.ParameterName = "@" + "PARAM1" +parametroProcedure.Value = 1 +comandoProcedure.Parameters.Add(parametroProcedure) + +parametroProcedure = ConexaoFactory.CreateParameter() +parametroProcedure.DbType = DbType.String +parametroProcedure.ParameterName = "@" + "PARAM2" +parametroProcedure.Value = "VALOR2" +parametroProcedure.Size = DirectCast(parametroProcedure.Value, +String).Length +comandoProcedure.Parameters.Add(parametroProcedure) + +comandoProcedure.CommandType = CommandType.StoredProcedure +comandoProcedure.CommandText = procedureName +comandoProcedure.Transaction = _ConexaoTransaction +comandoProcedure.CommandTimeout = +comandoProcedure.Connection.ConnectionTimeout +comandoProcedure.Prepare() + +Retorno = comandoProcedure.ExecuteScalar() _______________________________________________ mono-bugs maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-bugs
