>>Reccount can be used with cursors, but the cursors must be true cursors (created with NOFILTER clause).
>Naomi,
>
>It is generally safer to use _TALLY as it will return the expected value regardless of how the cursor is created while RECCOUNT() may not under certain situations. Why use something works "most" of the time when there is an option that works "all" of the time?
I don't object to using _TALLY and I agree it may be a better and easier alternative.
If it's not broken, fix it until it is.
My Blog