firebird-net-provider

[Firebird-net-provider] ExecuteScalar() and "Attempt to reopen an open cursor"

[Maarten K. <mk...@xs...>]

Hi,

When I execute the method ExecuteScalar() twice on the same FbCommand =
within the same transaction (without changing anything on the FbCommand =
instance), an exception is thrown with the message "Attempt to reopen an =
open cursor" at the second call.=20
When I "rewrite" the statements using ExecuteReader() (and close the =
reader in between the calls) everthing is oke. Is there a way I can =
close the cursor in between calls of the ExecuteScalar() method or could =
this be a bug?

Kind regards,

Maarten Kroon

Re: [Firebird-net-provider] ExecuteScalar() and "Attempt to reopen an open cursor"

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

Hello:

> When I execute the method ExecuteScalar() twice on the same FbCommand 
> within the same transaction (without changing anything on the FbCommand 
> instance), an exception is thrown with the message "Attempt to reopen an 
> open cursor" at the second call. 
> When I "rewrite" the statements using ExecuteReader() (and close the 
> reader in between the calls) everthing is oke. Is there a way I can 
> close the cursor in between calls of the ExecuteScalar() method or could 
> this be a bug?


Can you send a test case ?? Which version of the .NET Provider are you 
using ??





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] ExecuteScalar() and "Attempt to reopen an open cursor"

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

Hello:

I think it's fixed now, in CVS in both branches 1.0 and 1.1, i will try 
to give some more testing to the fix later today, thanks very much.



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain