I know the feeling. :)
That's why I prefer to use a query to acomplish such task if possible.
>
>I had tried creating a "RealCount" function, but it messed up my system by leaving the record pointer at eof(). Eventually I got it to reset the record pointer properly. I stared at this code for an hour before I realised my stupid mistake with it (I was moving the record pointer back in the wrong alias).
>
>
>
>
>>You'll have to count reords using COUNT command or SELECT statement (maybe in UDF).
>>
>>>I've been using a class I think I got here called GridFooter which I think was developed by Dorin Vasilescu. I only recently noticed that if I use this string:
>>>
>>>transform(reccount(thisform.icmainalias)) + ' records'
>>>
>>>as the gridfooter's cTotalLabelExpression, deleted records get counted (of course).
>>>
>>>What expression can I put in there to not count the deleted records?
--sb--