3. I'm not sure if this is fastest but this would be my preferred solution select client, max(date) as lastinvoicedate ; from winhst ; where client=myclient ; group by client ; order by client ; into cursor temp ? temp.LastInvoiceDate
Sytze de Boer wrote: > What's the quickest way > > *There's an indexed table > 1 > Sele winhst > seek myclient > if found() > scan while client=myclient > lastinvoicedate=date > endscan > endif > > 2 > select client,date from winhst where client=myclient into cursor temp > if !eof() > go bott > lastinvoicedate=date > endif > > > > > > _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
