firebird-net-provider

[Firebird-net-provider] HasRows error in FbDataProvider

[Timothy S. <tim...@ya...>]

Hi all,

I'm a new subscriber to these lists so forgive me if
this has already been brought up (I just started using
firebird yesterday). In any case, I'm porting over
some code to use the firebird .net provider and my
code was something like this:

FbDataReader reader = cmd.ExecuteQuery();
while(reader.Read()) {
  //do stuff
} 

if(!reader.HasRows()) {
   empty = true;
}

using the OleDbDataReader, if the reader has no
records, hasrows returns false. using the Net provider
for Firebird, hasrows ALWAYS returns true, even if I
execute a query which I know has no rows. Of course,
this can be circumvented, but I figure this is
something that needs to be reported.

-Tim


	
		
__________________________________
Do you Yahoo!?
Yahoo! Tax Center - File online by April 15th
http://taxes.yahoo.com/filing.html

Re: [Firebird-net-provider] HasRows error in FbDataProvider

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

Hello:

>using the OleDbDataReader, if the reader has no
>records, hasrows returns false. using the Net provider
>for Firebird, hasrows ALWAYS returns true, even if I
>execute a query which I know has no rows. Of course,
>this can be circumvented, but I figure this is
>something that needs to be reported.
>  
>

I know, hasrows need to determine wheter a query returns rows or not but 
without fetch data, and there are now way (know by me at least) for get 
that info in firebird (for select statements, i can return false for non 
query statements)






--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain