Click above to get retro games delivered to your door ever month!

 DBGOTO() function
 Position record pointer to a specific identity
------------------------------------------------------------------------------
 Syntax

     DBGOTO(<xIdentity>) --> NIL

 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) <xIdentity> is the record number.  In other data formats,
     <xIdentity> is the unique primary key value.  <xIdentity> could be an
     array offset or virtual memory handle if the data set is in memory
     instead of on disk.

 Returns

     DBGOTO() always returns NIL.

 Description

     DBGOTO() is a database function that positions the record pointer in the
     current work area at the specified <xIdentity>.  In an Xbase data
     structure, this identity is the record number because every record, even
     an empty record, has a record number.  In non-Xbase data structures,
     identity may be defined as something other than record number.

 Examples

     .  This example saves the current record number, searches for a
        key, 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

           DBGOTO( nSavRecord )             // Restore the record
                                            // pointer position
           RETURN ( lFound )

 Status:  Enhanced

 See also:  BOF(), DBGOBOTTOM(), DBGOTOP(), DBSEEK(), DBSKIP(), EOF(), GO