FOUND()

Class

Fields and Records

Purpose

Function to return whether a record was found

Syntax

FOUND([<workarea | alias>])

See Also

BOF(), CONTINUE, EOF(), FIND, LOCATE, LOOKUP(), RLOOKUP(), SEEK, SEEK()

Description

The FOUND() function returns .T. if a FIND, SEEK, LOCATE or CONTINUE operation was successful. The FOUND() function returns .F. if one of the above operations fails. If the optional <workarea/alias> is specified, then the function will operate in the required workarea. The FOUND() function should be used with the SEEK, FIND, LOCATE or CONTINUE commands for testing the success or failure of the operation.

Example

use accounts
set index to acc_no
seek "00751"
if found()
    change noclear
else
    dialog box "Customer not found."
endif

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer