BUG: AbsolutePosition Property Returns Different Results (191515)

MORE INFORMATION

Steps to Reproduce Behavior

1. Start a new Standard EXE project.
2. From the Project menu, choose References and select "Microsoft Remote Data Objects 2.0".
3. Add a Command button to the new form.
4. Paste the following code into the General Declaration section of the form: NOTE: You must modify the connection settings to match your configuration and choose a table for the rdoResultset that returns rows. This code uses the sample Customer table.

         Dim rdEnv As rdoEnvironment
         Dim Cn As New rdoConnection
         Dim Rs As rdoResultset
   
         Private Sub Command1_Click()
           Rs.AbsolutePosition = 5                   'Or whatever.
           MsgBox Rs.rdoColumns("custid")
         End Sub
   
         Private Sub Form_Load()
   
           rdoErrors.Clear
           Set rdEnv = rdoEnvironments(0)
   
           With Cn
              .CursorDriver = rdUseServer      'The problem cursor.
              '.CursorDriver = rdUseOdbc      'This works OK.
              .Connect = "uid=<MyUID>;pwd=<MyPassword>;dsn=<MyServer>"
              .EstablishConnection rdDriverNoPrompt, False
               rdEnv.rdoConnections.Add Cn
           End With
   
          Set Rs = Cn.OpenResultset("select custid from customer", _
              rdOpenStatic)
   
         End Sub
   					

5. Run the project by pressing the F5 key. Click the Command1 button and note that the message box returns the value for the last row in the Resultset. Click it a second time and notice that the value in the Message box is correct for the row referred to by the AbsolutePosition property.
6. Stop the project and uncomment the ".CursorDriver = rdUseOdbc" line and comment the ".CursorDriver = rdUseServer" line. Run the project again and notice that the message box has the correct values every time you click the Command button.