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 )

Seealso

DBGOTO(), LASTREC(), RECNO(), SET DELETED, SET FILTER