Wait for a command to continue executing

First of all, minor correction: OSQL will be phased out by Microsoft and they recommend using the utility you've already specified, SQLCMD.



My suggestion is that, rather than running the command prompt and executing a "Keys" command on the resulting window, to utilize the WScript.Shell object to execute the command line and have it wait for the command to return before continuing.  Information on Wscript.Shell and related objects can be found at http://msdn.microsoft.com/en-us/library/ahcz2kh6(v=VS.85).aspx



Here is my suggestion for the code you've posted (JScript so you will need to adapt).

function Test()

{

var ShellObj = Sys.OleObject("WScript.Shell");

ShellObj.Run(ComandoCriarTabela + "2.Nucleo\SQLServer\1.sql", 1, true);

}

This will execute exactly the commandline you want to within a windows shell.  The "true" parameter indicates to wait until the command completes before returning.  I believe this will do what you need it to do.

Change your code to the following:

Function LGComponentes

    Dim ShellObj

    Set ShellObj = Sys.OleObject("WScript.Shell")

    Call ShellObj.Run(ComandoCriarTabela & "1.LGComponentes\SQLServer\1.sql -o " &DirLog&"1.txt", 1,  true)

End Function

Note the underlined code.  Two problems I corrected here.  First, the second parameter after your command line, what is indicated as 1 in the code I've pasted, was missing entirely.  Secondly, instead of commas seperating parameters, you were concatenating the true parameter to the command line.



As noted above, please read http://msdn.microsoft.com/en-us/library/d5fk67ky(v=vs.85).aspx for more information about the specific syntax of using the Run command of the shell object.

I would suggest looking at using the commandline portion of the SQL Server Client (osql IIRC) and then creating a WScript.Shell object instance to run it.  When done properly, this will wait until the SQL execution is complete and the shell returns before it moves on.

Thanks for your attention Robert.

I'm totally new on TestComplete and Scripting world. Could you be more clear for me please?



I appreciate.

Thanks again for your time.



Here is the code adapted for VBScript:



Function LGComponentes

    ShellObj = Sys.OleObject("WScript.Shell")

    ShellObj.Run(ComandoCriarTabela & "1.LGComponentes\SQLServer\1.sql -o " &DirLog&"1.txt" & 1 & true)

End Function



And it returns the messages that I attached on this post. Any idea about how I can replace the code to adapt it perfectly?

Here is how I'm using the function. Is it correct?



Call directUIHWND.Keys("01 - LGComponentes[F2]1.LGComponentes[Enter][Enter]")

Call directUIHWND.Keys(CaminhoDaPasta3)

Call directUIHWND.Keys("Like %1%[F2]1.sql[Enter][BS]")

LGComponentes 'Replace the 3 lines below

'Call TestedApps.cmd.Run(1, True)

'Call Aliases.cmd.wndConsoleWindowClass.Keys(ComandoCriarTabela&"1.LGComponentes\SQLServer\1.sql -o " &DirLog&"1.txt[Enter]Exit[Enter]")

'Call Delay(10000)

Call directUIHWND.Keys(CaminhoDaPasta4)

Call directUIHWND.Keys("1.LGComponentes[Down]")

Log.Message("01.LGComponentes ready!!!")

In your call to Run, the "1" and "true" are parameters of the RUN function...  As I understand VBScript, you are concatenating the "1" and "true" as part of the commandline string.  That is incorrect.  



Secondly, you should, I believe, make sure you use "dim" and "set" to assign the ShellObj.

dim ShellObj

set ShellObj = Sys.OleObject("Wscript.Shell")

Third, I think you need to use a Call with your LGComponentes function within your actual script code.



Again, there are a few examples of how to implement the Run method of the WScript.Shell object on the MSDN site.  I'd suggest you check out those examples as they are in VBScript.

I´m  using  Oracle 9i (SQLPLUS)  for Run some scripts for Creation table. But when i run the scripts  i need a Wait for the Other 

Ex:



While 1.sql End Script

I move on to the Other, that is the case in 2.sql.



I took a peek in and found the Post "WScript.Shell"which is used in the CMD.

I'm new to automation and do not know how to use the "WScript.Shell"in my Code.



Code follows in SQLPLUS.



Sub Oracle9i



  Dim ConsoleCmd

  Dim BaseScrip9i, SenhaBaseScrip9i

 

    Call TestedApps.SqlPlus.Run (1, True)



Set ConsoleCmd = Aliases.SqlPlus.wndConsoleWindowClass



''' Connecting to Oracle 9i

   BaseScrip9i = "TS_F_ORA9_20112%%%%%%[ Enter]

   SenhaBaseScrip9i  = " %%%%%%[Enter]

  

Typing in''''Console SQLPLUS

   Call ConsoleCmd.Keys (BaseScrip9i)

   Call ConsoleCmd.Keys (SenhaBaseScrip9i)

  

End Sub



Can someone help me.

Robert, thanks for your attention and sorry about taking so long to give you an answer.

I'm totally new on Scripting. Please, be patient.



The problem is on the line below. I called the Function named "LGComponentes" and TestComplete returned me the erros attached.

    ShellObj.Run(ComandoCriarTabela & "1.LGComponentes\SQLServer\1.sql -o " &DirLog&"1.txt" & 1 & true)



I've declared the ShellObj inside the Sub.

    Dim ShellObj

    Set ShellObj = Sys.OleObject("Wscript.Shell")



Hope you can keep help me until I fix this problem.



Thanks.

I tried to edit my last replay, but it wasn't possible. So I want to ask another question.



How do I use the commands Sys.WaitChild, Sys.WaitProperty, and Sys.WaitWindow?



I know that I'm using CommandPrompt, but maybe I can, after call EXIT inside the prompt, use one of the commands above to wait while my Script is running. Or I didn't understand those commands descriptions?

When you call the Run method, it should be done as 



Call ShellObj.Run(.....)  That's probably why you're getting the error you're getting.