>>Hi Cetin,
>>
>>I solved my problem with record count in grids -simply by using COUNT TO myVar FOR etc...
>>
>>I just forgot that I had already tried RECCOUNT(), which always counts the whole file, while COUNT allows for expressions..
>>
>>Rolf
>
>Rolf,
>Yes :)
>If buffering is not an issue select approach doesn't move the pointer.
>Cetin
BTW if you'd use count sometimes you could speed it up :
select child
seek(master.id,'child','childfk')
count while child.childfk=master.id to nVar
* or if you need extra expression
count while child.childfk=master.id for ExtraCriteria to nVar
Cetin