ClearSelect statement [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== 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.

^Parameter^Description^
|//cursorvar//|If specified, //cursorvar// identifies a cursor previously established with a Select...By statement. If c//ursorvar// is not specified, the current active select list is cleared (cursor zero). //cursorvar// is an integer value of 0 to 8.|


**{{{guides:programming:programmers_reference_manual:caution.gif?28x21}}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|Select...By]]
 
==== Example ====
 
<code>
* Clears all cursors
For counter = 0 To 8
       ClearSelect counter
Next counter
</code>