Difference between revisions of "FIND"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=FIND=
 
 
 
==Class==
 
Indexing
 
 
 
 
==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
+
    edit
 
else
 
else
  dialog message "Record not found."
+
    dialog message "Record not found."
 
endif
 
endif
 
</code>
 
</code>
Line 40: Line 33:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
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