When I run 1 SQL query. The Speed to run the SQL is too slow.I don't know when it complete to continue another command. If the SQL complete There will be 2 situations: Error or not. If there is error, one msgbox appear and the mgbox must be close(by click method). if there is no error, another button will be Visible. Because the Speed to run the SQL is too slow, so how can I know which situation happen?. I use WaitProperty but I didn't work and after that I try to use the follow:
while not(VbWindow("").Dialog("").WinButton("OK").Exist) and not (VbWindow("1").(ActiveX("").Exist)
' Click this button to close dialog
But the speed is more slow and it can't work
Please help me
I suggest that you use a control variable, assign some value to that variable before executing the Sql and change it's value after Sql execution is completed (you can do it by returning the value from the function in which you have called that Sql command). Now continuosly check for the value of the variable, if it posses the changed value then you can use the Exist function to click or not to click the buttons.
Sorry i din't have the actual code because i din't face such a situation, hope it works for you.