Results 1 to 2 of 2

Thread: multi seek in ADO, dont work

  1. #1

    Thread Starter
    PowerPoster
    Join Date
    Mar 2005
    Posts
    2,586

    multi seek in ADO, dont work

    Code:
    Option Explicit
    Dim CONN As ADODB.Connection, RS As ADODB.Recordset
    Sub TEST_MULTISEEK()
    
    If CONN Is Nothing Then
        Set CONN = New ADODB.Connection
        CONN.Open _
                "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                                                    "Data Source=C:\DATABASE\GIZE.mdb;" & _
                                                    "Jet OLEDB:Engine Type=4;"
    End If
    
    Set RS = New ADODB.Recordset
    RS.Open "MOVIM_SINGOLO_CB", CONN, adOpenKeyset, adLockPessimistic, adCmdTableDirect
    
    RS.Index = Array("CB", "SP1")<<<<<<<<<<< herror here
    RS.Seek Array("CB9", "94"), adSeekFirstEQ
    
    End Sub
    note:
    Field CB and SP1 fields are indexed

  2. #2
    PowerPoster
    Join Date
    Feb 2012
    Location
    West Virginia
    Posts
    14,205

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width