C5_FIND

 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

 

Advertisements

2 responses to “C5_FIND

  1. Pingback: DB Commands | Viva Clipper !

  2. Pingback: C5 Commands | Viva Clipper !

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.