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.2 . The Guide To CA-Clippe - <b>dbseek()</b> http://www.X-Hacker.org [<<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

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