RE: Progress Bar in SQL SELECT (Posted by Om Rajan) - www.foxite.com

Hi Stefan
i agree with u, but suppose data row not more then 100000 apox. in table then query wil not show query bar.

> > 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.
> >
>
> In addition to Glenn's comment, unfortunately showing progress for time-consuming processes slows down the process itself even more.
> There is a built-in progress bar for that purpose that you can hide or show by setting Talk and Notify Off or On.
>
>

> CREATE CURSOR temp (test i)
> LOCAL i
> FOR i = 1 TO 2000
> 	INSERT INTO temp VALUES (i)
> ENDFOR
> 
> LOCAL lcTalk, lcNotify
> lcTalk = SET("Talk")
> lcNotify = SET("Notify")
> SET TALK ON
> SET NOTIFY ON
> SELECT * FROM temp T1 JOIN temp T2 ON T2.test <> T1.test INTO CURSOR temp2
> SET NOTIFY &lcNotify
> SET TALK &lcTalk
> RETURN
>