>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

select dist site_id from training into cursor crstemp_1 order by site_id
select recno() as Id, site_id from crstemp_1 into cursor crstemp order by 1