[<<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