[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 FIND*
 Search an index for a specified key value
------------------------------------------------------------------------------
 Syntax

     FIND <xcSearchString>

 Arguments

     <xcSearchString> is part or all of the index key of a record to
     search for, and can be specified either as a literal string or as a
     character expression enclosed in parentheses.  If an expression is
     specified instead of a literal string, FIND operates the same as SEEK.

 Description

     FIND is a database command that searches an index for the first key
     matching the specified character string and positions the record pointer
     to the corresponding record.

     If SOFTSEEK is OFF and FIND does not find a record, the record pointer
     is positioned to LASTREC() + 1, EOF() returns true (.T.), and FOUND()
     returns false (.F.).

     If SOFTSEEK is ON, the record pointer is positioned to the record with
     the first key value greater than the search argument and FOUND() returns
     false (.F.).  In this case, EOF() returns true (.T.) only if there are
     no keys in the index greater than the search argument.

     FIND is a compatibility command and therefore not recommended.  Its
     usage is superseded entirely by the SEEK command.

 Examples

     .  These examples show simple FIND results:

        USE Sales INDEX Branch NEW
        FIND ("500")
        ? FOUND(), EOF(), RECNO()         // Result: .F. .T. 85
        FIND "200"
        ? FOUND(), EOF(), RECNO()         // Result: .T. .F. 5
        FIND "100"
        ? FOUND(), EOF(), RECNO()         // Result: .T. .F. 1

 Files   Library is CLIPPER.LIB.


See Also: EOF() FOUND() RECNO() SEEK SET INDEX SET ORDER
This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson