FOUND( )

Topic group Related topics Example

Indicates if the last-issued search command found a match.

Syntax

FOUND([<alias>])

<alias>

The work area you want to check.

Description

FOUND( ) returns true if LOCATE, CONTINUE, SEEK, LOOKUP( ), or SEEK( ) found a match in the current or specified table. FOUND( ) returns false if no previous search has been performed in that work area, or if the last search was unsuccessful. You can perform searches in different work areas and maintain the status of each FOUND( ) operation, independent of the other work areas.

If tables are linked by a SET RELATION TO command, dBASE Plus searches the related tables as you move in the active table with normal navigation or with a search command. This allows you to determine if there is a match in related tables.

When SET NEAR is ON and you use SEEK or SEEK( ),

FOUND( ) returns true if an exact match occurs.

FOUND( ) returns false for a near match, and the record pointer is moved to the record whose key immediately follows the value searched for.

When SET NEAR is OFF, FOUND( ) returns false if a match does not occur.

OODML

Check the return value of the Rowset object’s findKey( ) or findKeyNearest( ) method.