guides:programming:programmers_reference_manual:clearselect

ClearSelect statement

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

ClearSelect[cursorvar]

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.

* Clears all cursors
For counter = 0 To 8
       ClearSelect counter
Next counter
  • guides/programming/programmers_reference_manual/clearselect.txt
  • Last modified: 2024/10/14 18:18
  • by 127.0.0.1