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