[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 ORDKEYGOTO()
 Move to a record specified by its logical record number in the controlling
 order
------------------------------------------------------------------------------
 Syntax

     ORDKEYGOTO(<nKeyNo>) --> lSuccess

 Arguments

     <nKeyNo> is the logical record number.  If the value specified does
     not satisfy the scope or for condition for the order, the record pointer
     is positioned at the end of file.

 Returns

     ORDKEYGOTO() returns true (.T.) if successful; otherwise, it returns
     false (.F.).

 Description

     ORDKEYGOTO() is the complement to ORDKEYNO().  ORDKEYNO() returns the
     logical record number (i.e., its position in the controlling order) of
     the current record, and ORDKEYGOTO() moves the record pointer to the
     specified logical record.

     Tip:  This function can be useful when displaying scroll bars.  If
     the user clicks on a certain position on the scroll bar, you can move to
     the corresponding record by calling ORDKEYGOTO().

     By default, this function operates on the currently selected work area.
     It will operate on an unselected work area if you specify it as part of
     an aliased expression.

 Examples

     .  This example shows the difference between physical and logical
        record number:

        USE Customer
        SET INDEX TO First   // Make records in first name
                             // order
        ORDKEYGOTO(100)      // Go to the 100th logical record
        ? RECNO()            // Returns the physical record
                             // number
        ? ORDKEYNO()         // Returns 100, the logical
                             // record no

 Files   Library is CLIPPER.LIB.


See Also: ORDKEYCOUNT() ORDKEYNO()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson