Mark -

You could also use

COUNT TO nRecords FOR NOT DELETED()

>first part did it
>thanks
>~M
>
>>COUNT or SELECT-SQL.
>>

>>set deleted on
>>count to nRecords
>>

>>or
>>

>>set deleted on
>>select count(*) from myTable into array laCounts
>>?laCounts[1]

>>
>>The difference is that the first will count the current table state and the second only commited changes (from the table on disk, unless you use WITH BUFFERING option).
>>
>>>hi all,
>>>I want to initialise some setting in a program depending on record in a dbf file. i was thinking of
>>>

>>>use table1
>>>if reccount() > 0
>>>...
>>>

>>>the only problem is that this table could have a deleted record, very hard to use excl and pack and i want reccount() to only work with non-deleted records, is there a way to do this?
>>>~M