Results 1 to 4 of 4
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    FAST find method (2000)

    i dont know if existis a nother good method to find in rset...?

    RSD1.CursorLocation = adUseClient
    SSQL = "SELECT * FROM STAFF ORDER BY MATR ASC"
    'RSD1.Open SSQL, CNSQL2, adOpenKeyset, adLockReadOnly
    Set RSD1 = CNSQL2.Execute(SSQL)

    RSD1.MoveFirst
    While Not RSD1.EOF
    If Me.CERCA_MATR.Text = RSD1.Fields("MATR").value Then
    Call RIEMPI_CAMPI_RICERCA
    Exit Sub
    End If
    RSD1.MoveNext
    Wend

    note:
    - have just uindexed MATR fiel
    - i need all field rset from tabale

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: FAST find method (2000)

    Look up the Seek method of the Recordset object in the ADO help, or see Utilizzo del metodo Seek con oggetti ADO (ActiveX Data Objects) su un recordset Jet

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: FAST find method (2000)

    Resolved ... tks.
    But, admit have found the record how to navigate based the actually record founded to the nex or to the previuos?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: FAST find method (2000)

    You can use the MoveNext and MovePrevious methods for that.

Posting Permissions

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