>What’s wrong with the COUNT TO command?
>I wanted to count records in 2 cursors. I tried that cause I rather not to use RECCOUNT cause it counts also deleted records.
>So I tried the COUNT TO and the weirdest things happened.
>In one deleted method I count and then go to the record selected and DELETE, but it doesn’t deleted anything. So I got rid of the COUNT and went back to RECCOUNT and all was fine again.
>On the other method I COUNT and IF expression I RETURN TO MASTER, but it just terminates the whole app.
>So because of that I have to use the RECCOUNT
>Any ideas why this is happening?
Rather than doing this, you can get the count using a SQL SELECT; the _TALLY result contains the count of matching tuples, and doesn't move the record pointer in the base table.