Jump to content

Recommended Posts

Posted (edited)

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


image.png.81b19dcb374d0da531ea9b3a20f06e04.png

 

Edited by cesinha87
Posted

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.

If I posted any code, assume that code was written using the latest release version unless stated otherwise. Also, if it doesn't work on XP I can't help with that because I don't have access to XP, and I'm not going to.
Give a programmer the correct code and he can do his work for a day. Teach a programmer to debug and he can do his work for a lifetime - by Chirag Gude
How to ask questions the smart way!

I hereby grant any person the right to use any code I post, that I am the original author of, on the autoitscript.com forums, unless I've specifically stated otherwise in the code or the thread post. If you do use my code all I ask, as a courtesy, is to make note of where you got it from.

Back up and restore Windows user files _Array.au3 - Modified array functions that include support for 2D arrays.  -  ColorChooser - An add-on for SciTE that pops up a color dialog so you can select and paste a color code into a script.  -  Customizable Splashscreen GUI w/Progress Bar - Create a custom "splash screen" GUI with a progress bar and custom label.  -  _FileGetProperty - Retrieve the properties of a file  -  SciTE Toolbar - A toolbar demo for use with the SciTE editor  -  GUIRegisterMsg demo - Demo script to show how to use the Windows messages to interact with controls and your GUI.  -   Latin Square password generator

Posted

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

image.png.851d93914a1a93cba259a874e971ea35.png


 

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...