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