>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
RECCOUNT() function just read the header of the DBF to see how many records that DBF has, no matter if they are deleted or not. As Naomi suggest you must COUNT the records by yourself. Just don't forget to add a TAG based on DELETED() just to make sure that everything is optimizable.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.