>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

If you want to work with non-deleted records only (it is quite normal approach) then you should
SET DELETED ON
either for the whole application, or each private data session (if you use them).