[<<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