hello,
i get the error message : "Error on method execution" when i launch the
stored proc sub_tot_budget but she is compiled and commmited.
the code of the assembly is :
[CODE]
using System;
using System.IO;
using System.Collections.Generic;
using System.Text;
using FirebirdSql.Data.FirebirdClient;
namespace FirebirdSql.ExternalEngine.Samples
{
public class Employee
{
private string GetConnectionString()
{
FbConnectionStringBuilder csb = new
FbConnectionStringBuilder();
csb.ContextConnection = true;
csb.Charset = "UNICODE_FSS";
return csb.ToString();
}
public FirebirdSql.Data.Server.FbResultSet
SubTotalBudget(string headDepartament)
{
FbConnection connection = new
FbConnection(this.GetConnectionString());
connection.Open();
string sql = "SELECT SUM(budget), AVG(budget), MIN(budget),
MAX(budget) FROM " +
"department WHERE head_dept = @HeadDepartament";
FbCommand select = new FbCommand(sql, connection);
select.Parameters.Add("@HeadDepartament",
FbDbType.Char).Value = headDepartament.Trim();
return new
FirebirdSql.Data.Server.FbResultSet(select.ExecuteReader());
}
}
}
[/CODE]
Have you an idea for this problem ??
Thanks
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
