PRB: rdConcurRowver Availability Incorrect in Books Online (182954)

MORE INFORMATION

Steps to Reproduce Behavior

1. Create a standard exe in Visual Basic. Form1 is created by default. Under Project References, select Microsoft Remote Date Object 2.0.
2. Place two CommandButtons on the form and paste the following code in the form.
   
   Note You must change UID <username> and PWD <strong password> to the correct values before you run this code. Make sure that UID has the appropriate permissions to perform this operation on the database.

          Option Explicit
          Dim en As rdoEnvironment
          Dim rs As rdoResultset
          Dim cn As rdoConnection
          Dim sqlstr As String
   
          Private Sub Command1_Click()
             sqlstr = "select * from tablename"
              Set rs = cn.OpenResultset(sqlstr, rdOpenKeyset, _
                 rdConcurRowVer)
          End Sub
   
          Private Sub Command2_Click()
             If Not (rs Is Nothing) Then
                rs.Close
             End If
             cn.Close
             Unload Me
          End Sub
   
          Private Sub Form_Load()
            Set en = rdoEnvironments(0)
            en.CursorDriver = rdUseServer
            Set cn = en.OpenConnection(dsName:="datasourcename", _
              Prompt:=rdDriverNoPrompt, _
              Connect:="uid=<username>;pwd=<strong password>;database=PUBS;")
            Command1.Caption = "resultset"
            Command2.Caption = "quit"
          End Sub
   						

3. Replace the datasourcename and the table name above.
4. The table name should be changed to different tables, such as primary key and timestamp, to try out the various combinations (just primary key, just timestamp, just id, id and timestamp, and none of the above).
5. Run the form and execute the resultset click button. Pause the execution.
6. Select "add watch" from the debug window. Create a watch for rs.
7. When the watch window appears, click the plus sign (+) and look at locktype. Note that the only time locktype shows rdConcurRowVer is when the table has a timestamp and a primary key.