Promotic
WikipediaLinkedInYoutubeTwitterFacebook

Find - method of object AdoRecordset

Description:
Searches a AdoRecordset for the row that satisfies the specified criteria.
Syntax:
Find(sCriteria As String, [nSkipRows As Long], [nSearchDirection As Long], [vStart As Variant])
Calling:
oRs.Find sCriteria, nSkipRows, nSearchDirection, vStart
Parameters:
sCriteria(String) A value that contains a statement specifying the column name, comparison operator, and value to use in the search. For example "Country='Czech republic'", "Date>#7/22/2011#", "Country LIKE C*", etc.
nSkipRows[optional] (Long) Specifies the row offset from the current row or vStart bookmark to begin the search. The preset value is 0.
nSearchDirection[optional] (Long) Value that specifies the search direction:
1 (default) - (adSearchForward) Searches forward from the starting position. If no match, the record pointer is placed after the last record (EOF).
-1 - (adSearchBackward) Searches backward from the starting position. If no match, the record pointer is placed before the first record (BOF).
vStart[optional] (Variant) Define the starting position (Bookmark). If not defined, the starting position will be the position of the current active record. If a valid Bookmark is defined, it will be used as starting position. It is also possible to use standard numeric constants for defining the start position:
0 (default) - (adBookmarkCurrent) Current record.
1 - (adBookmarkFirst) First record.
2 - (adBookmarkLast) Last record.
Note:
The found record is selected as the current record.
Example:
Setting the position of the active record to the first record that has in the ("name") column the value of ("pi"), over the PmAdo object ("/TestAdoDb"), that is already connected to the database (see DbOpen), using the SQL query ("SELECT * FROM table1").
Dim oDb, oRs
Set oDb = pMe.Pm("/TestAdoDb")
Set oRs = oDb.RsOpen("table1", "SELECT * FROM table1", "cursor:static;")
  oRs.Find("name='pi'", 0, 1, 1)
End If
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice