163
MOVE_TO
Purpose
To move the file pointer, of a specified DBF and IDX files, to a specified
position.
Syntax MOVE_TO(file% [,index%], record_number%)
Remarks “file%” is an integer variable i
n the range of 1 to 5, indicating which DBF file to
be accessed.
“index%
” is an integer variable in the range of 1 to 3, indicating which IDX file
to be accessed. If it is not specified, the default IDX file which keeps the
original data sequence will be used.
“record_number%
” is a positive integer variable, indicating the ordinal number
of the record where the file pointer is moved to.
Example
MOVE_TO_NEXT
Purpose To move the file pointer, of a specified DBF and IDX files, one record forward.
Syntax MOVE_TO_NEXT(file% [,index%])
Remarks “file%
” is an integer variable in the range of 1 to 5, indicating which DBF file to
be accessed.
“index%” is an integer variable in the range of 1 to 3, indicating which IDX file
to be accessed. If it is not specified, the default IDX file which keeps the
original data sequence will be used.
Example
MOVE_TO_NEXT(1, 1)
MOVE_TO_PREVIOUS
Purpose To move the file pointer, of a specified DBF and IDX files, one record backward.
Syntax MOVE_TO_PREVIOUS(file% [,index%])
Remarks “file%
” is an integer variable in the range of 1 to 5, indicating which DBF file to
be accessed.
“index%
” is an integer variable in the range of 1 to 3, indicating which IDX file
to be
accessed. If it is not specified, the default IDX file which keeps the
original data sequence will be used.
Example
RECORD_COUNT
Purpose To get the total number of the records in a specified DBF file.
Syntax A% = RECORD_COUNT(file%)
Remarks “A%” is an integer variable to be assigned to the result.
“file%
” is an integer variable in the range of 1 to 5, indicating which DBF file to
be accessed.
Example
TotalRecord_1% = RECORD_COUNT(1)