Difference between revisions of "FIND"
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Search for a key in the master index file | Search for a key in the master index file | ||
| Line 32: | Line 25: | ||
find &m_find | find &m_find | ||
if found() | if found() | ||
| − | + | edit | |
else | else | ||
| − | + | dialog message "Record not found." | |
endif | endif | ||
</code> | </code> | ||
| Line 40: | Line 33: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
| + | [[Category:Indexing]] | ||
| + | [[Category:Indexing Commands]] | ||
Latest revision as of 16:47, 11 November 2009
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 Server, Recital
