Re: [Firebird-net-provider] Help returning multple rows from a stored procedure

[Carlos G. A. <car...@te...>]

Hello:

> FbCommand command = new FbCommand(
> 	"SELECT P_POLICYID, P_POLICY FROM usp_pmi_GetPolicyList", 
> 	connection, 
> 	connection.BeginTransaction());
> command.CommandType = System.Data.CommandType.StoredProcedure;

You don't need to set the CommandType to CommandType.StoredProcedure in 
this case, because what you are really executing is a SELECT statement, 
try removing it and tell the results :)



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain