DBFind Action

Searches a Recordset for the row that satisfies the specified criteria.

Use

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

An error will occur if a current row position is not set before calling DBFind. Any action that sets row position, such as the DBMove action, should be called before calling DBFind.

This action is only supported if the Server property for the corresponding DB Connection object is set to DBServerADO.   

Parameters

Recordset  -  (Required)

Specifies the name of the Recordset object to search.

Search Criteria  -  (Required)

Specifies the column name, comparison operator, and value to use in the search.

Only a single-column name may be specified. This action does not support multi-column searches

The comparison operator in may be ">" (greater than), "<" (less than), "=" (equal), ">=" (greater than or equal), "<=" (less than or equal), "<>" (not equal), or "like" (pattern matching).

The value may be a string, floating-point number, or date. String values are delimited with single quotes or "#" (number sign) marks (for example, "state = 'WA'" or "state = #WA#"). Date values are delimited with "#" (number sign) marks (for example, "start_date > #7/22/97#").

If the comparison operator is "like", the string value may contain an asterisk (*) to find one or more occurrences of any character or substring. For example, "state like 'M*'" matches Maine and Massachusetts. You can also use leading and trailing asterisks to find a substring contained within the values. For example, "state like '*as*'" matches Alaska, Arkansas, and Massachusetts. Asterisks can be used only at the end of a criteria string, or together at both the beginning and end of a criteria string, as shown above. You cannot use the asterisk as a leading wildcard ('*str'), or embedded wildcard ('s*r'). This will cause an error.

Find Option  -  (Required)

Specifies the direction of the search within the Recordset. Use one of the pre-defined Find Option constants.

Example

The following example connects to an Access database and uses the DBFind action to search the open recordset for a value saved in the variable varSearch. Connect DBConnect (testConnection, DBServerADO, Provider=Microsoft.Jet.OLEDB.4.0; Data Source=@test\crm.mdb; Mode=Share Deny None; Persist Security Info=False;) DBOpen (recordset1, testConnection, Table1, DBUseClient, DBOpenDynamic, DBLockReadOnly, DBCmdTable) Find DBMove (recordset1, DBMoveFirst) DBFind (recordset1, ="EntityRef = " & varSearch, DBFindForward) recordset1.EOF = False MsgBox(Found, =varSearch & " was found.", MsgInformation, MsgOKOnly) recordset1.EOF = True MsgBox(Not Found, =varSearch & " was not found.", MsgCritical, MsgOKOnly)   Close DBClose (recordset1) DBDisconnect (testConnection) StopMacro

See Also

DBConnect Action | DBDisconnect Action | DBOpen Action | DBClose Action | DBFind Action | DBMove Action | DBAddNew Action | DBBeginTrans Action | DBCancelUpdate Action | DBCommitTrans Action | DBDelete Action | DBRollbackTrans Action | DBSeek Action | DBUpdate Action

© 2004-2022 looksoftware. All rights reserved.