FIND

From Recital Documentation Wiki
Revision as of 12:05, 29 April 2009 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

Class

Indexing


Purpose

Search for a key in the master index file


Syntax

FIND <key expression>


See Also

DBXDESCEND(), DESCEND(), DESCENDING(), DTOS(), EOF(), FOUND(), INDEX, LOCATE, LTOS(), SEEK, SEEK(), SET EXACT, SET TALK, STR()


Description

The FIND command searches for the specified <key expression> in the master index file. If the <key expression> is found, then the FOUND() function will return .T., and the EOF() function will return .F.. If the <key expression> is not found, then the FOUND() function will return .F., and the EOF() function will return .T.. Character expressions used as <key expressions> may include blanks.

The & macro function must be used to substitute the required <key expression> into the quoted string when the <key expression> is contained in a field or variable.

If the DESCEND() function is used to create the index key, it must also be used in the search <key expression>. Tag indexes built with the DESCENDING keyword require the use of the DBXDESCEND() function in the <key expression>. The DESCENDING() function can be used to determine whether a particular tag was built with the DESCENDING keyword.


Example

use patrons index events, name
m_find = "OPERA"
find &m_find
if found()
    edit
else
    dialog message "Record not found."
endif


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer