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.

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