Move the pointer to the specified identity
GO[TO] <xIdentity> | BOTTOM | TOP
<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.
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.
. 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 )
DBGOTO(), LASTREC(), RECNO(), SET DELETED, SET FILTER