>I need a fast COUNT for my table. Is there something faster than COUNT FOR? My code is COUNT FOR empty(mydate)... :)
Robert,
Keeping an index for mydate would make it fast. To make it faster you could use a filtered index expression and just count by setting order to it. Also keep a tag on deleted() (index on deleted() tag dummy). But IMO using SQL for counting is far better because it wouldn't move the rec pointer unnecessarily (still keep an index on mydate).
select cnt(*) from mytable where mydate={} into array aMyCount
return iif(type("aMyCount")= "U",0,aMyCount[1])
Cetin