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()