>Anybody know if the following code could be simplified?
>
>select dist site_id from training into cursor crstemp
>select dist reccount() as sitesrepresented from crstemp into array aSitesRepresented
>
>
>The need is to get a single number that will be used in a report. The above works and the array appears to be global, but I was not overly comfortable with the solution.
>
>Thanks

Does

SELECT COUNT(DISTINCT site_id) FROM training INTO CURSOR/ARRAY etc

work for you????