>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.