Maybe this problem was already reported but here is what i found.
I tried to use stored procedures but i was getting a lot of errors.
I was suprised cause my code was working fine with the fb odbc drivers.
Finally i found error -
when it's trying to prepare sql command for storproc it's calling
fbcommand.cs ->
private void ExecuteCommand(CommandBehavior behavior)
{
this.ExecuteCommand(behavior, true);
}
ExecuteCommand(CommandBehavior behavior, bool returnsSet)
after this -> BuildStoredProcedureSql(string spName, bool returnsSet)
in this moment we have returnsSet=true in the buildstoredpro...
later we have condition
if (returnsSet)
{
sql = "select * from " + paramsText.ToString();
}
else
{
sql = "execute procedure " + paramsText.ToString();
}
so the result will be select * from storedprocedurename but it should be execute procedure...
Cheers,
Jakub.
------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
