On Fri, Mar 19, 2010 at 4:27 PM, Charlie Coleman <[email protected]> wrote:
> Anyway, if what you're doing is a sort of once-in-a-while type thing the > performance over SQL probably won't be noticeable. But if it's in a tight > loop of a hundred thousand or so clients, using the benefits of VFP and its > index structure may be significant. ------------------------------------------------------ Why wouldn't you then use the power of SQL to get you the max by client for a large volume instead of jumping around ? Select ClientID, Max(InvDate) as InvoicedOn from theTable group by ClientID Now iterate through that to do whatever process you need? Works for int, string or other data type. Seeking the wrong client and then a skip -1? Now that was a throw back in technology. Then you have to test that you have the proper one to begin with. -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell _______________________________________________ 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.
