Hi all.I need to make the code below, wait until the "EXIT " is informed to move to the next line of code.I am using "Call Delay" but it isn't resolving, since not all commands invoked take the same amount.Call TestedApps.cmd.Run(1, True) 'open the Command PromptCall Aliases.cmd.wndConsoleWindowClass.Keys(ComandoCriarTabela&"2.Nucleo\SQLServer\1.sql[Enter]Exit[Enter]")Call Delay(5000)Here are the variable declaration for your knowledge:ComandoCriarTabela = "sqlcmd -S " &Servidor& " -d " &Database& " -U " &Usuario& " -P " &Senha& " -i " &Caminho&""Servidor = "srv-tsbd\sql2k"Database = "TS_F_SQL2K_20112"Usuario = "homol"Senha = "tssql2k"Caminho = "D:\Scripts\Scripts_Criacao_Banco\"It is working fine. The command is correct. I just need a solution for my problem. How to make my code wait until EXIT is informed?Hope someone can help me.Thanks.

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).aspxHere 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 FunctionNote 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&colon;Function LGComponentes ShellObj = Sys.OleObject("WScript.Shell") ShellObj.Run(ComandoCriarTabela & "1.LGComponentes\SQLServer\1.sql -o " &DirLog&"1.txt" & 1 & true)End FunctionAnd 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!!!")

Wait for a command to continue executing

36 Replies

joffre
Regular Contributor
15 years ago
Here I am again.

Robert, thanks for your time.

Your idea worked. But how will I close this sqlplus process to go to the other script line?

I did this way: Funcao(Acesso&"\1.LGComponentes\Oracle\1.sql"), where Acesso = "sqlplus TS_F_ORA9_EFGH/dev@srv-tsbd-9i @D:\Scripts\Scripts_Ora9i".

Hope you can help.
tristaanogre
Esteemed Contributor
15 years ago
Does SQLPlus not automatically exit after executing the SQL query? I would expect it does it if has command line parameters.

You'll need to research within the SQLPlus user documentation to find the correct syntax and commands within SQL Plus to do what you want to. Once you have that figured out, the method you've coded to use will work well.
joffre
Regular Contributor
15 years ago
Sadly, it doesn't.

After finish the sql script, it waits another command. If I type "EXIT", it will close (attached). I'm trying on Oracle's forums if anyone know how to do everything in one line.

If someone here find anything about it, please, let me know.
joffre
Regular Contributor
15 years ago
Hi friends.

I found a way to make everything I need in just one line.

sqlplus TS_F_ORA9_JOFFRE/dev@srv-tsbd-9i @D:\Scripts\Scripts_Ora9i\1.LGComponentes\Oracle\1.sql > D:\Scripts\Logs9i\1-1.txt

The problem now is that the part responsible for my log creation isn't being readed by TestComplete (I think). The script is executed, the output inside the command prompt is shown, but the log that should be created inside D:\Scripts\Logs9i isn't created.

Any ideas?
joffre
Regular Contributor
15 years ago
sqlplus TS_F_ORA9_JOFFRE/dev@srv-tsbd-9i @D:\Scripts\Scripts_Ora9i\1.LGComponentes\Oracle\1.sql > D:\Scripts\Logs9i\1-1.txt

I think the Function that you guys wrote for me isn't accepting spaces after the "1.sql".

On my log message the code line is correct, but I think TestComplete isn't reading the entire line to execute it.

Any idea about how I'll make it work?
AlexanderM
Staff
15 years ago

Hi Joffre,

The problem now is that the part responsible for my log creation isn't being readed by TestComplete (I think).

Is there a difference if you run your command using the Funcao function and using cmd.exe? If not, this means that you'll need to review the command. Otherwise, please post a few images demonstrating the difference.

Forum Discussion

Wait for a command to continue executing

36 Replies

Recent Discussions

Issue with 'Keys' Operation

Name error : name 'Sys' is not defined.

Issue with edge browser

Related Content

If object exist execute, if not continue

Incrementing Project.Variables from command line test execute

Command Line Execution