Mike yearwood wrote: > No. There is no such performance penalty. There may be a slight > benefit to using 1 line of code versus 4, but that's about it. If you > tried to use a Rushmore aware command like SET FILTER or LOCATE, they > would run slower if an order is set. > > The advice you got about SQL commands is incorrect. VFP SQL re-opens > the cursors in their own workareas so it can avoid any ORDER/SET > FILTER you've already put on the cursors. > Mike
Of course - my mistake. I was indeed thinking of Rushmore aware commands and in particular FOR clauses ... Paul Newton _______________________________________________ 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.

