[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 DBGOTO()
 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 Xbase data structure (.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, 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

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


See Also: BOF() DBGOBOTTOM() DBGOTOP() DBSEEK() DBSKIP()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson