HasRows bug

Frans · Post by **Frans** » Tue 27 Dec 2005 09:12

I am using 8.1.7.4 server and a version 8 client. The documentation clearly implies that OracleDataReader HasRows property is valid before the first Read operation (see the example in the docs). Howeve, this is not true.
1 qry.Connection.Open();
2 reader = qry.ExecuteReader();
3 result = reader.HasRows;
4 result = reader.Read();
With the debugger it was easy to see that result (and HasRows)was still false after evaluation of line 3, but changed to true after evaluation of line 4 (inspection of HasRows revealed it had changed to true also).

Greetings
Frans

Paul · Post by **Paul** » Tue 27 Dec 2005 12:43

We reproduced your problem and fixed it. This fix will be included in the next builds of OraDirect .NET.

achib · Post by **achib** » Wed 25 Jan 2006 13:10

Hi Paul!

I use OraDirect 2.5.3. When i use oracle client 8.0.6 the HasRows property works properly but when i use oracle client 9.0.2.4 HasRows= false but Read() methods return true and rows. You must fix the bug!
Alexei