Re: OO4O bug in V1.0.61

Zuehlsdorf wrote:
>
> 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

OO4O 2.1 is production but, and there's always a big but, it is ONLY bundled w/Programmmer 2000. call your Oracle sales rep.

steve chapman Received on Tue Jan 21 1997 - 00:00:00 CST