Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Refreshing a label caption
Message
From
13/04/2000 19:48:58
 
 
To
10/04/2000 18:55:11
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00357731
Message ID:
00359568
Views:
8
>Hi All,
>
>I have a modal form I am using to build some files and display the results to the users. The processing is broken down into a number of methods. Before each method is called I assign a new value to a label field on the form and refresh the screen thereby telling the user what is going on. This all works fine except when the method executes a SQL statement. Then the label is not refreshed until after the method has executed. Here is the code:
>
>ThisForm.lbl1.caption = "Running some SQL."
>ThisForm.refresh
>ThisForm.RunSomeSQL
>
>The label caption is not refreshed until after the RunSomeSQL method has completed. Let me repeat that the above code works when the method does not execute a SQL statement. This is too wierd to me.
>
>Thanks

Another workaround is to use:

jold_talk=set('talk')
set talk on

*define your label message
*refresh your form
*then run the sql statement

set talk &jold_talk



the user will see a query thermometer...

**note, this will cause a very tiny performance decrease, but the user will swear that the query is running faster :-)


You probably already knew this...
Thanks,

Stacy



Black Mountain Software, Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform