General information
Category:
Coding, syntax & commands
>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????
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only