[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
DBSEEK()
Move to the record having the specified key value
------------------------------------------------------------------------------
Syntax
DBSEEK(<expKey>, [<lSoftSeek>]) --> lFound
Arguments
<expKey> is a value of any type that specifies the key value
associated with the desired record.
<lSoftSeek> is an optional logical value that specifies whether a
soft seek is to be performed. This determines how the work area is
positioned if the specified key value is not found (see below). If
<lSoftSeek> is omitted, the current global _SET_SOFTSEEK setting is
used.
Returns
DBSEEK() returns true (.T.) if the specified key value was found;
otherwise, it returns false (.F.).
Description
DBSEEK() moves to the first logical record whose key value is equal to
<expKey>. If such a record is found, it becomes the current record and
DBSEEK() returns true (.T.). Otherwise, DBSEEK() returns false (.F.)
and the positioning of the work area is as follows: for a normal (not
soft) seek, the work area is positioned to LASTREC() + 1 and EOF()
returns true (.T.); for a soft seek, the work area is positioned to the
first record whose key value is greater than the specified key value.
If no such record exists, the work area is positioned to LASTREC() + 1
and EOF() returns true (.T.).
For a work area with no active indexes, DBSEEK() has no effect.
DBSEEK() performs the same function as the standard SEEK command. For
more information, refer to the SEEK command.
Notes
. Logical records: DBSEEK() operates on logical records.
Records are considered in indexed order. If a filter is set, only
records which meet the filter condition are considered.
. Controlling order: If the work area has more than one active
index, the operation is performed using the controlling order as set
by DBSETORDER() or the SET ORDER command. For more information,
refer to the SET ORDER command.
. Network environment: For a shared file on a network, moving to
a different record may cause updates to the current record to become
visible to other processes. For more information, refer to the
Network Programming chapter in the Programming and Utilities guide.
Examples
. In this example, DBSEEK() moves the pointer to the record in
the database, Employee, in which the value in FIELD .cName. matches
the entered value of cName:
ACCEPT "Employee name: " TO cName
IF ( Employee->(DBSEEK(cName)) )
Employee->(ViewRecord())
ELSE
? "Not found"
END
Files: Library is CLIPPER.LIB.
See Also:
DBGOBOTTOM()
DBGOTOP()
DBSKIP()
EOF()
FOUND()
SEEK
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson