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
  • No labels