>>Is there a way to run an SQL SELECT and get ALL the rows of data and still get a COUNT(*)? I have tried this, but it looks like like I'm just getting the last row of data along with the count. TIA, Chuck.
>
>The problem you're having is that COUNT is an aggregate function, meaning it will group records into a single record in the result based on what's in your GROUP BY expression. If you don't specify a GROUP BY, then everything gets grouped into a single record.
>
>What you want to do is just SELECT * and look at _TALLY for the count.
Barbara,
I haven't worked with _TALLY before. Can you give me a quick example. It sounds like it may be a lot better of a solution than what I am currently trying to work with, i.e., SELECTing INTO ARRAY, and then examining the ARRAY for count value. TIA, Chuck.
Chuck Henry