>>>I need a fast COUNT for my table. Is there something faster than COUNT FOR? My code is COUNT FOR empty(mydate)... :)
>>
>>I've found mark & cetin answers, and sure they are in the right way, not me, but how about issue a 'seek' and then 'count while' ?.
>Carlos,
>This is fast and sure a right way. I prefer SQL because I don't like playing with rec pointer for such operations. Underlying code might lead to side effects (ie:in an edit session valid would fire).
>Cetin
Do you mean that SQL does not move record pointer in the table ?. Ok. Good thing.
Saludos,
A.G.P.
---------