>Local lnTotalOrder, lcCustID > >lnTotalOrder = 0 >lcCustID = "0008" > >Seek &lcCustID && Seek "0008" >Do while Customer.Cust_ID=&lcCustID > lnTotalOrder = lnTotalOrder + Customer.OrderAmount > Skip >Enddo >Return (lnTotalOrder) >You should avoid using & as often as possible. This should be faster than what you had:
>Select Customer.Cust_ID, sum(Customer.OrderAmount) As lnTotalOrder; >from Customer into cursor temp where Customer.Cust_ID="0008" Group by Customer.Cust_ID >The answer to your question is not easy. SELECT will read the entire cust_id index from the server to the client PC's CPU to determine which records to examine. It will then read the record data while doing the sum.