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