Ah hah!
Thanks much, there's always so much to learn.
Cheers,
>Hi Jim,
>
>_TALLY will always give you correct result. RECCOUNT() will give wrong result if a cursor is created as a filter on the source table.
>
>>My example was merely that -- an example. As I had need for the alias later on in my program, this example merely demonstrated that the alias disappeared.
>>
>>In any case, I think it odd that _tally would be considered "the right way". There doesn't seem to be any explicit reason in the language itself for this preference, so I'll assume there is some implementation dependency I am unaware of.
>>
Jim Nelson
Newbury Park, CA