> 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
hth
-Stefan