I'm working with VB6 into a SQL Server 7 database. I've been using this code to open recordsets:
Code:
            Set objCmd = New ADODB.Command
            objCmd.ActiveConnection = PROJ_DB
            objCmd.CommandType = adCmdStoredProc
            With objCmd
                .CommandText = "sel_candidate_where_candno_ordered"
                .Parameters.Refresh
                .Parameters(1) = txtSeek
                Set rsCand = .Execute
            End With
            Set objCmd = Nothing
The problem is, it doesn't allow for bookmarks, so populating grids, etc. are problems. There must be a way to open it as a Keyset using adOpenKeyset, such as:
Code:
    rsCand.CursorType = adOpenKeyset
Can anyone help me out?? Thanks...