>>>>>Note that reccount() returns the total number of records - and it does so quickly. The total number of records may included deleted records, and records that don't match the current filter criteria. To get only records that you see on screen, use the COUNT command instead - or use an SQL - SELECT command.
>>>>
>>>>is it the same
>>>>

>>>>nump=count("mytable")
>>>>

>>>>?
>>>
>>>There is no COUNT function, but you can do
>>>
>>>set deleted on
>>>select count(*) from myTable into array laCount
>>>
>>>lnRecords = laCount[1]
>>
>>can i use reecount and keep count in mind if i run into something later?
>
>Reccount() will show you the total number of records in a table. Typically reccount() is rarely used, while _tally is frequently used. For instance after a select statement, you should NEVER use reccount(), instead you should always use _tally.

Hi Toren I understand you should not use reccount() if you don't add the nofilter or readwrite clause to the select, but other than that is fine to use it, or am I wrong?

Luis