|
|
Stored Procedure select ...: msg#00227
|
Subject: |
Stored Procedure select ... |
I have a stored procedure that returns to me an entire table..
I tried 2 ways to execute this procedure im my c# code...
fbDA fbDataAdapter = new FbDataAdapter();
fbDA.SelectCommand = new FbCommand("EXECUTE PROCEDURE CONSULTA_SEMEN", fbConnection);
FbTransaction ft = fbConnection.BeginTransaction();
FbCommand fc = new FbCommand("EXECUTE PROCEDURE CONSULTA_SEMEN", fbConnection, ft);
fc.CommandType = CommandType.StoredProcedure;
fc.ExecuteReader();
this 2 ways returned to me nothing and when i execute this procedure in firebird its works fine...
Anyone can help ??
---------------------------------------------------------- "I throw myself into the sea Release the wave, let it wash over me To face the fear I once believed The tears of the dragon, for you and for me"
Bruce Dickinson - Tears of the Dragon
§€NT€NC€Ð - MSN - sir_undertaker@xxxxxxxxxxx eduardo.beninca@xxxxxxxxx
----------------------------------------------------------
|
| |