>>>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)
>
>Thank you very much
You're welcome.
If it's not broken, fix it until it is.
My Blog