> My 'senior' memory has let me down again...
>
>
> A while ago I saw a Progress Bar when I was creating a new table via SQL using a Select .. FROM ... INTO routine.
>
> I don't see that in my apps at the moment which have quite a number of such codes .. can anyone point to how one makes this Bar visible ?
>
> I have some Select statements that are taking a very long time and I want to be certain that they are being processed.
>
>
> Regards
> -Bryan

Hi Bryan

A memento design pattern is the best way to handle this. There are several SET commands that need to be changed and then reverted. Failing to undo them by failing to call the procedure to undo them - easy enough due to human error, can make a mess.

Here is a class that does the job better:

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.