Position to a specific record in a table
GO[TO] [RECORD] <expN> | BOTTOM | TOP [IN <alias>]
The GOTO command is used to position the record pointer to the specified record in a table. The pointer is moved to the record whose number matches that specified in <expN>. By default, the GOTO command operates in the currently selected workarea. If the number specified in <expN> is not a valid record number, a 'Record is out of range' error message will be given.
If the BOTTOM keyword is specified, then the record pointer is positioned to the last record in the table.
If the TOP keyword is specified, then the record pointer is positioned to the first record in the table.
The IN <alias> clause is used to move the record pointer of an open table in another workarea.
If the command SET PCFILTER is ON, then the use of GOTO <expN> bypasses any FILTER <condition> that may be in effect with the SET FILTER TO command. The record pointer may be positioned to records that are marked for deletion, even if SET DELETED is ON. If SET CLIPPER is set ON, and GOTO RECORD <expN> is greater than the number of records in the table, the Recital/4GL does not report an error. Rather than reporting an error, the Recital/4GL sets EOF() to .T., and FOUND() to .F.. If SET RELATION TO is in effect for the active table, then defined relationships are maintained after the record pointer is positioned.
goto top browse goto 10
Recital Server, Recital