[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 GO
 Move the pointer to the specified identity
------------------------------------------------------------------------------
 Syntax

     GO[TO] <xIdentity> | BOTTOM | TOP

 Arguments

     <xIdentity> is a unique value guaranteed by the structure of the
     data file to reference a specific item in a data source (database).  In
     a .dbf, identity is the record number.  In other data formats, identity
     is the unique primary key value.

     BOTTOM specifies the last logical record in the current work area.

     TOP specifies the first logical record in the current work area.

 Description

     GO[TO] is a database command that positions the record pointer in the
     current work area at the specified identity.  In an Xbase data
     structure, this identity is the record number because every record, even
     an empty record, has a record number.  In data structures of different
     design, identity may be defined as something other than record number.

 Examples

     .  This example saves the current record number, searches for a
        key, and then restores the record pointer to the saved position:

     FUNCTION KeyExists( xKeyExpr )

        LOCAL nSavRecord := RECNO()      // Save the current record
                                         // pointer position
        LOCAL lFound

        SEEK xKeyExpr
        IF ( lFound := FOUND() )
           .
           .  < statements >
           .
        ENDIF

        GOTO nSavRecord      // Restore the record pointer position

        RETURN ( lFound )


See Also: DBGOTO() LASTREC() RECNO() SET DELETED SET FILTER
This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson