>>>Reccount() gives a total of all records in a table whether deleted, or not. What is the most efficient way to determine the number of 'not' deleted records?
>>>
>>>Many thanks!
>>
>>You have to count them.
>>Select count(*) from yourtable where !deleted() into array laDummy
>>?laDummy
>>Note that you must have Set Deleted On for this to work.
>
>There is no need to use deleted() in the query. Functions that take an alias are dangerous in SQL because they do not reference the cursors in the query. Only set deleted on.
Mike,
what would than be according to your knowledge a better SQL select statement than the one provided here by Tore?
Regards,
Koen