[Firebird-net-provider] Re: finalising the problem of FbDataReader

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

Hello:

> I've managed to alter one function to return DataTable and it works quite
> well...
> 
> Now about FbDataReader,  if I rewrite the function ending to:
> ...
>  Result := myCommand.ExecuteReader(CommandBehavior.CloseConnection);
>  myTransaction.Commit;
> ...
> 
> then the error is "Dynamic SQL Error SQL error code = -504 Cursor unknown"
> and the transaction seems to be open.


Thanks, fixed in CVS, see that using CommandBehavior.CloseConnection 
,when you close the reader the transaction is rollbacked and the 
connection closed.




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.