SQL SELECTstatement fired in a timer that polls a login table for the existence of other users. The regular version changes the currently selected work area by default, however
SELECT ... INTO ARRAYdoes not, and my cure is to use this syntax. Few (less than 20) records are expected in the result.
SELECT ... INTO CURSORcould usefully have a 'NOSELECTCURSOR' option for this reason. Obviously it is good practice to use an '.. IN WorkArea' clause to avoid ambiguity wherever possible, but not all statements give you this option.