>>>>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]
>
>that's interesting. why don't you just count?
>
>
>count
>?_tally
>
?eof()
Count command moves the record pointer. SQL select doesn't.