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