[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 DBSEEK() 
 Move to the record having the specified key value
------------------------------------------------------------------------------
 Syntax

     DBSEEK(<expKey>, [<lSoftSeek>], [<lLast>]) --> 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.

     <lLast> is specified as true (.T.) to seek the last occurrence of
     the specified key value.  False (.F.), the default, seeks the first
     occurrence.

     Note:  This parameter is only supported for specific RDDs.  DBFNTX
     is NOT one of them.

 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, it returns false (.F.).  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 which
        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.  This function will not affect the locked status of any
        record.

 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()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson