Difference between revisions of "FIND"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
==Class== | ==Class== | ||
Indexing | Indexing | ||
| Line 32: | Line 29: | ||
find &m_find | find &m_find | ||
if found() | if found() | ||
| − | + | edit | |
else | else | ||
| − | + | dialog message "Record not found." | |
endif | endif | ||
</code> | </code> | ||
Revision as of 12:05, 29 April 2009
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
