Promotic

Find - method of the AdoRecordset object

Description:
Search for a record in the AdoRecordset object that satisfies the specified criteria.
Syntax:
Empty Find(String sCriteria, [Long nSkipRows], [Long nSearchDirection], [Variant vStart])
Parameters:
sCriteria(String) The value that contains a statement - specifies 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 default value is 0.
nSearchDirection[optional] (Long) The value that specifies the search direction:
1 (default) - (adSearchForward) Searches forward from the starting position. If no match, then the current record is set after the last record (the EOF property).
-1 - (adSearchBackward) Searches backward from the starting position. If no match, then the current record is set before the first record (the BOF property).
vStart[optional] (Variant) Specifies the starting position (Bookmark).
If not set, then the starting position will be the position of the current record.
If a valid Bookmark is defined, then it will be used as starting position.
It is also possible to use standard numeric constants for specifying 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"), in the PmaAdo object ("/TestAdoDb"), that is already connected to the database (see the DbOpen method), using the SQL query ("SELECT * FROM table1").
JavaScriptVBScriptSelect and copy to clipboard

var oDb = pMe.Pm("/TestAdoDb");
var oRs = oDb.RsOpen("table1", "SELECT * FROM table1", "cursor:static;");
if (oRs)
{
oRs.Find("name='pi'", 0, 1, 1);
}

History:
Pm8.01.00: Created
PROMOTIC 9.0.27 SCADA system documentation MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r.o.