>>Hi all,
>>I have a table with at least 200000 records in it.
>>IdField and Payment are its fields.
>>What is the fastest way to getting sum of payment for some records?
>>Is SUM command suitable for this?
>>SUM Payment ALL FOR IdField=2134 TO SumPayment
>

>select sum(Payments) as TotalPayments from myTable where IDField = 2134 into cursor c_TotalPayments
>
>?  nvl(c_TotalPayments.TotalPayments,0)

If there's an index on IdField, the following may be faster

local SumPayment, IdToDo
SumPayment = 0
IdToDo = 2134

&& set order to the index on IdField
&& best set talk Off

if( seek(m.IdToDo, 'AliasName') )
    sum Payment rest while (IdField == m.IdToDo) to SumPayment
endif