CLEAR.SELECT

CLEAR.SELECT, CLEARSELECT

Top  Previous  Next

 

The CLEAR.SELECT command (synonym CLEARSELECT) clears an active select list. It is useful to prevent use of a select list by a subsequent command when, for example, the SELECT was performed in error.

 

 

Format

 

CLEAR.SELECTClears select list 0, the default list

 

CLEAR.SELECT list.numberClears the specified list (0 to 10)

 

CLEAR.SELECT ALLClears all select lists

 

 

@SYSTEM.RETURN.CODE is returned as the list.number when clearing a specific select list, 11 when clearing all select lists or a negative error code.