> > Hi Glenn
> > thats a good idea, but do with or without procedure for query.
> > c the time difference in both query
> >
> > Select * From Products Into Cursor NewProducts
> >
> > Select *, This.MoveBar(m.lnCount,Recno()) From Products Into Cursor NewProducts
>
> The first query is faster and will always be than the second query. :-)
>
> Months ago, I've learned from Stefan Wuebbe to avoid using 'This/Thisform' in a query as much as possible because it tends to slow down it's process.
>
> I, myself, would not want this type of example applied to any of my query due to the same reason. But for some people, they prefer seeing something visual rather than facing an idle form with an hour glass for a long time during a long execution of query.
>
>
> (coffee)
> DeepLogic Computers & Software / Acer Lending Investor

This approach is best.

http://foxridgesoftware.com/Blogs/tabid/84/EntryID/2/Default.aspx

Mike Yearwood
Microsoft MVP Visual FoxPro 2008



We have enough youth. We need a fountain of smart!
There may be many ways to skin a cat, but there are very few right ways to do it.