Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
X-Hacker.org- CA-Clipper 5.3 . Guide To CA-Clipper - <b>find*</b> http://www.X-Hacker.org [<<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

Online resources provided by: http://www.X-Hacker.org --- NG 2 HTML conversion by Dave Pearson