Unanswered: OraDynaset RowPosition issue with OO4O and VB6
I'm having an odd problem using Oracle Objects for OLE from a Visual Basic application. I have the following code:
Set objRS = objDB.CreateDynaset(strSQL, ORADYN_READONLY + ORADYN_NOCACHE)
After the CreateDynaset method executes, objRS is at RowPosition = 11 (which is the last record in the dynaset in this case), rather than RowPosition = 1 as I would expect. The MoveFirst call has no effect (I added it just for testing, but the results are the same without it), so only the last row gets processed.
Any suggestions on what I am doing wrong or how to resolve this issue? TIA.