Click or drag to resize

DbSkip Function

X#
Move the record pointer relative to the current record.

Namespace:  XSharp.RT
Assembly:  XSharp.RT (in XSharp.RT.dll) Version: 2.19
Syntax
 FUNCTION DbSkip(
	nRecords,
	uArea
) AS LOGIC CLIPPER
Request Example View Source

Parameters

nRecords (Optional)
Type: Usual
The number of logical records to move, relative to the current record.
A positive value means to skip forward, and a negative value means to skip backward.
If nRecords is omitted, a value of 1 is assumed.
uArea (Optional)
Type: Usual
Specifies the work area name or number for a table from which the value must be retrieved.

Return Value

Type: Logic
TRUE if successful; otherwise, FALSE.
Remarks
Attempting to skip forward beyond the last record positions the work area to LastRec() + 1 and EOF() returns TRUE.
Attempting to skip backward beyond the first record positions the work area to the first record and BOF() returns TRUE.
By default, this function operates on the currently selected work area.
It can be made to operate on an unselected work area by specifying it within an aliased expression or by calling the overload that accepts a workarea parameter (a workarea number or alias ).
DBSkip() is the functional equivalent of the SKIP command.
For more information, refer to the SKIP command.
Tip Tip
Logical records: DBSkip() operates on logical records.
If the work area has an active order list, records are considered in controlling order.
If a filter is set, only records which meet the filter condition are considered. Shared mode: For a shared file, moving to a different record can cause updates to the current record to become visible to other processes.
Examples
This example demonstrates a typical use of the DBSkip() function:
X#
1DBGoTop()
2DO WHILE (!EOF())
3    QOut(_FIELD->Name)
4    DBSkip()
5ENDDO
See Also