DBSeek Action

Searches the index of a Recordset object to quickly locate the record that matches the specified values, and sets that record as the current record.

Use

If DBSeek does not find the desired row, no error occurs, the cursor is positioned after the last record in the Recordset object, and the EOF property is set to True.

Before using the DBSeek action with an ADO data source, you should ensure that the Index property has been set for the Recordset.

Parameters

Recordset - (Required)

Specifies the name of the Recordset object to search.

Key Value - (Required)

The key value to use for searching the Recordset object. If a Recordset index includes multiple fields, specify the value for each field separated by semi-colons.

Seek Option - (Required)

Specifies how the records in the Recordset object should be compared with the specified key value. Use one of the pre-defined Seek Option constants.

Note

For DDM data sources, the DBSeek action is available for files that have key fields specified. For ADO data sources, support for this action depends upon the OLE DB provider and the Command Type that was used when the Recordset was opened. To use the seek action, a Command Type of DBCmdTableDirect must be specified. The advanced view in the Connection tab of the Database Description dialog shows the behaviour for a particular Recordset. If Supports Seek is set to True, then the DBSeek action is available. Otherwise, the DBSeek action is not available for that Recordset.

DBSeek Action

Use

Parameters

Note

See Also