Position record pointer to a specific identity

     DBGOTO(<xIdentity>) --> NIL


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


     DBGOTO() always returns NIL.


     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.


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

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


One response to “C5_DBGOTO

  1. Pingback: C5DG-3 RDD Reference | Viva Clipper !

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.