Table of Contents

ClearSelect statement

Description

Sets the list of record keys for a specified cursor to null.

Syntax

ClearSelect[cursorvar]

Parameters

The ClearSelect statement has the following parameter.

ParameterDescription
cursorvarIf specified, cursorvar identifies a cursor previously established with a Select…By statement. If cursorvar is not specified, the current active select list is cleared (cursor zero). cursorvar is an integer value of 0 to 8.

Caution: If you exit a ReadNext loop before exhausting the select list, you must clear the select list using ClearSelect. Otherwise, your results may be unpredictable.

See Also

Select...By

Example

* Clears all cursors
For counter = 0 To 8
       ClearSelect counter
Next counter