I agree it's weird. Have you tried some work-arounds? 1) Add a command between the Refresh and the RunSomeSQL commands. Call a dummy method for instance. 2) Try putting a LockScreen command around the first two commands and/or around the RunSomeSQL command.
Just WAGs, but I'm working on a new SQL-Server project and I'll probably run into this one within a week or two. Let us know what works if anything.
HTH
Barbara
>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