Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

GO | GOTO Command

Visual Studio .NET 2003

Moves the record pointer to the specified record number.

GO [RECORD] nRecordNumber [IN nWorkArea | IN cTableAlias]

-or-

GO TOP | BOTTOM [IN nWorkArea | IN cTableAlias]

-or-

GOTO [RECORD] nRecordNumber [IN nWorkArea | IN cTableAlias]

-or-

GOTO TOP | BOTTOM [IN nWorkArea | IN cTableAlias]

Parameters

RECORD nRecordNumber
Specifies the physical record number to move the record pointer to. You can omit GO or GOTO entirely and specify just the record number. If you specify just the record number, you can move the record pointer only within the current work area.
IN nWorkArea
Specifies the work area of the table in which the record pointer is moved.
IN cTableAlias
Specifies the alias of the table in which the record pointer is moved.
TOP
Positions the record pointer on the first record in the table. If the table has an ascending index in use, the first record is the record with the lowest key value. If the index is in descending order, the first record is the record with the highest key value.
BOTTOM
Positions the record pointer on the last record in the table. If the table has an ascending index in use, the last record is the record with the highest key value. If the index is in descending order, the last record is the record with the lowest key value.

Remarks

GO and GOTO can be used interchangeably. These commands operate on the table in the current work area unless you specify another work area with the IN clause.

Example

CLOSE DATABASES
OPEN DATABASE (HOME(2) + 'data\testdata')
USE products  && Opens Products table
USE customer IN 0  && Opens Customer table
GO BOTTOM IN products
CLEAR
? RECNO('products')
GO TOP
? RECNO( )     && Displays 1
GO 5
? RECNO( )     && Displays 5

See Also

RECNO( ) | SELECT | SKIP

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.