Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting the SQL Select to display standard thermometer
Message
From
05/10/2001 11:09:31
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
04/10/2001 14:07:24
Larry Huisingh
Lockheed Martin Information Technology
Richland, Washington, United States
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00564278
Message ID:
00564802
Views:
11
Try SET TALK WINDOW NOWINDOW followed by SET TALK ON. The nowindow will suppress the "Selected x records in x seconds". The thermometer only appears if VFP decides the query will take some time. I've not researched what VFP thinks the criteria are.

>I have no forms or windows open, just the main screen. Wait a minute... now I'm confused. I just went back and tried the query again on the live data from within FPW's command window and I don't get the thermometer. It displays the total time taken to perform the query after the query is complete. There must be more to this than I can tell. Actually, I don't know if I've ever seen it on this particular query. I just know I've seen it before on other queries in my systems and don't know how to force it or if it's even possible. If we can't get it to work then I'll just have to be patient when I run the program knowing it might take a while.
>
>>It is unusial behaviour. How many windows/forms do you have open in application? Perhaps it is something to do with particular window/form property.
>>
>>>I have that very code right before my SQL select statement but over the course of the 17 seconds it takes to run there is no thermometer shown. Are there some other criteria that are used about when it will show a thermometer?
>>>
>>>>set talk on
>>>>and
>>>>set talk wind
>>>>
>>>>>I noticed that when long SQL Select queries are run in FPW 2.5 I see a thermometer pop up giving me a status of how the query is going. When I put the same query in my EXE I don't see it. Is there a setting that forces this to display in an executable or do I have to somehow create my own thermometer?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform