Metodo di ricerca ADO
❮ Riferimento completo dell'oggetto Recordset
Il metodo Find cerca un record in un Recordset che soddisfa un criterio specificato. Se la ricerca ha esito positivo, il puntatore del record punterà al primo record trovato.
Nota: prima di chiamare questo metodo è necessario impostare una posizione di riga corrente (come MoveFirst), altrimenti si verificherà un errore.
Sintassi
objRecordset.Find(criteria,skiprows,direction,start)
| Parameter | Description |
|---|---|
| criteria | Required. The column name, comparison operator, and value to use in the
search.
Examples: "Country='Norway'" Note: This method does not support multi-column searches (AND or OR) |
| skiprows | Optional. Specifies how many records beyond the current record to skip before beginning the search. Default is 0 |
| direction | Optional. A SearchDirectionEnum value that specifies the search direction |
| start | Optional. The starting position for the search |
SearchDirectionEnum Valori
| Constant | Value | Description |
|---|---|---|
| adSearchBackward | -1 | Searches backward from the starting position. Stops at the beginning of the Recordset. If no match, the record pointer is placed at the beginning of the Recordset |
| adSearchForward | 1 | Searches forward from the starting position. Stops at the end of the Recordset. If no match, the record pointer is placed at the end of the Recordset |
❮ Riferimento completo dell'oggetto Recordset