C5_DBGOTO

 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()



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.