[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
SKIP

    SKIP moves the record pointer forward or backward in the active
    database file.

Syntax

    SKIP <exp N1> [ALIAS <work area>/<alias>/(<expN2>)]

Argument

    <expN1> specifies the number of records to move the record pointer from
    the current position.  A positive value moves the record pointer
    forward and a negative value moves the record pointer backwards.  A
    zero argument flushes the current work area buffer to DOS buffers.

Option

    Alias: The ALIAS clause moves the record pointer in the designated
    work area instead of the current work area.

Usage

    SKIP without a numeric argument moves the current record position to
    the next record.  SKIPping backward beyond the beginning-of-file moves
    the pointer to the first record and BOF() returns true (.T.).  SKIPping
    forward beyond the end-of-file positions the record pointer at
    LASTREC() + 1 and EOF() returns true (.T.).

    If an index file is in use, SKIP moves the specified number of
    positions as defined by the index.

    Flushing Clipper buffers: Any command that causes a record to be
    read into Clipper's internal buffers flushes the current database file
    buffer to a DOS buffer if a change has been made to that buffer;s
    contents since it was read from disk.  SKIP 0 can be used to force a
    flush of the current database file buffer without causing record
    movement.  Note that the specific time information is written to disk
    depends on DOS unless you execute a COMMIT to force an actual disk-
    write.  SKIP 0 itself does not necessarily cause a disk write.  Note
    also that the command does not flush INDEX buffers.

Example

    The following demonstrates movement of the record pointer in a remote
    work area:

    SKIP ALIAS 4

    This is the same as:

    SELECT 4
    SKIP    
    SELECT 1

See Also: COMMIT RECNO() CONTINUE GOTO FIND LOCATE SEEK
This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson