OO4O bug in V1.0.61

Bug in Oracle Objects for OLE 1.0.61

I discovered a very nice bug which cost me two days and a lot of problems in our paper production plant.
We use Oracle Workgroup Server 7.2 with Netware 4.10 SFT III and Win 3.1 clients.

If the resultset contains exactly 20 rows the EOF flag of the recordset is not set correctly so the follwing code returns 21 rows (the last row is duplicate).

Set rsQuery = Db1.dbCreateDynaset(sSqlQuery, ORADYN_READONLY) do until rsquery.EOF
  print rsQuery(0)
  rsquery.MoveNext
loop

This code works correct:
Set rsQuery = Db1.dbCreateDynaset(sSqlQuery, ORADYN_READONLY + ORADYN_NOCACHE) The bug appears if the recordcount is a mutliple of the FetchLimit ( Default=20 )
 ( see "Tuning" in the help file ).

The bug is fixed in the newer Version 2.0.7 which I don't want to use because
- RSF 7.3 are needed

• accessing fields in a recordset is much slower
• a OCX control is still missing

Does anybody know something about Version 2.1 ?

Thanks,
Roger Zuehlsdorf
zuehlsdorf_at_aol.com
http://members.aol.com/zuehlsdorf/index.html Received on Tue Jan 21 1997 - 00:00:00 CST