# DBGOTO()

Position the record pointer to a specific location.

Syntax

  DBGOTO(<xRecordNumber>) --> NIL

Arguments

  <xRecordNumber> Record number or unique identity

Returns

  DBGOTO() always returns NIL.

Description

  This function places the record pointer,if working with a .DBF file, in selected or aliased work area at the record number specified by <xRecordNumber>.The position if not affected by an active index or by any enviromental SET condiction.
  Issuing a DBGOTO(RECNO()) call in a network enviroment will refresh the database and index buffers.This is the same as a DBSKIP(0) call. The parameter <xRecordNumber> may be something other than a record number.In some data formats, for example, the value of <xRecordNumber> is a unique primary key while in other formats,<xRecordNumber> could be an array offset if the data set was an array.

Examples

          The following example uses DBGOTO() to iteratively process
          every fourth record:

          DBUSEAREA( .T., "DBFNTX", "Sales", "Sales", .T. )
          //
          // toggle every fourth record
          DO WHILE !EOF()
             DBGOTO( RECNO() + 4 )
             Sales->Group := "Bear"
          ENDDO

Status

  Ready

Compliance

  This function is CA-Clipper compliant.

Files

  Library is rdd

See Also

- BOF()
- EOF()
- DBGOTOP()
- DBGOBOTTOM()
- DBSEEK()
- DBSKIP()