Command works in the CMD but not through AUTOIT

[cesinha87]

I am running the following script

$Command = @ComSpec & ' /k sqlcmd.exe -S ' & 'tcp:' & $db_ServerName & $db_InstanceName & ' -i ' & @ScriptDir & $sql_script
ConsoleWrite("cmd=" & $Command)
$rc = Run($Command, @SW_SHOW)

_FileWriteLog ($debug_log, 'Output Command:' & @CRLF & $Command)

which outputs the right command in the ConsoleWrite and in the _FileWriteLog. If I copy the command from the ConsoleWrite or _FileWritelog and paste on CMD my command works but through AutoIt nothing happens. Below is the command that my script outputs

 

Edited August 19, 2019 by cesinha87

[BrewManNH]

Your @SW_SHOW is in the parameter for the workingdir parameter, try putting something into the WorkingDir parameter and move the show flag one parameter over.

[Nine]

nvm

Edited August 20, 2019 by Nine

[cesinha87]

Thank you all, another quick question...

I am trying to FileWriteLog the $rc output.... when I do 

$rc = Run($Command, @SW_SHOW)

_FileWriteLog ($debug_log, 'Output Command:' & @CRLF & $rc)

I just get a number (which I believe it's the PID).... when I run through the CMD I get all the information below and that's what I was looking to have in the log as well




 

[Nine]

Look in help file for the example of StdoutRead function, you pretty much want to read the result of the run command as it is showed there...