Re: [Firebird-net-provider] Select stored procedures

[<car...@te...>]

Hello:

> Hi, im have some select stored procedures (retrieve rows) and others no 
> select (Inser, update, delete) the problem is when i call select 
> procedures because I need to do this select * from spSelect.
> I need to call in in the same way the select and no select stored 
> procedures in my .net aplication.  How can I get that, if it possible, 
> with .net firebird provider?

If you are using 1.5 version of the .net provider you can do that, you 
can execute stored procs only with the sp name as the 
FbCommand.CommandText, if it's a stored proc that return rows you can 
make a call to FbCommand.ExecuteReader and if it's a stored proc that 
performs inserts, updates or deletes you can call 
FbCommand.ExecuteNonQuery ( the provider will add the SELECT * or the 
EXECUTE PROCEDURE depending the FbCommand method you are calling )



--
Best regards

Carlos Guzmán álvarez
Vigo-Spain