Need help whit WINDOWS COMMAND LINE

[kmetski]

AutoItSetOption("WinTitleMatchMode",3)
AutoItSetOption("WinDetectHiddenText", 1)
Opt("TrayIconHide", 0) 

Run("SQLCMD",@SW_HIDE)
$sql = "use test"
WinWait("SQLCMD")
ControlSend("SQLCMD","","",$sql,0)
ControlSend("SQLCMD","","","{enter}",0)
ControlSend("SQLCMD","","","go",0)
ControlSend("SQLCMD","","","{enter}",0)
Sleep(10000)
WinKill("SQLCMD")
Exit

I can`t make it work when using @SW_HIDE

Probably because the windows command line don`t have a controlID.

When the window of the windows command line is visible everything is fine, but when i hide it does not work.

Any ideas.

Edited May 19, 2009 by kmetski

[Authenticity]

You need to wait for the window to exist, otherwise $win is nothing but 0.

Opt("WinTitleMatchMode",3)
Opt("WinDetectHiddenText", 1)
Opt("TrayIconHide", 0)

Run("SQLCMD", '', @SW_HIDE)

WinWait("SQLCMD")
$win = WinGetHandle("SQLCMD")
$sql = "use test"

ControlSend("SQLCMD", "", "", $sql)
ControlSend("SQLCMD", "", "", "{enter}")
ControlSend("SQLCMD", "", "", "go")
ControlSend("SQLCMD", "", "", "{enter}")
Sleep(10000)
WinKill($win)
Exit

[kmetski]

the real problem is that i cant send the commands to the windows cmd

[Authenticity]

What about ControlSetText or specifying a control in the third paramter?

[kmetski]

I will try that but WINDOWS COMMAND LINE does not have a control ID

[TurionAltec]

Does the app respond to StdIn? Maybe that might be better than trying to use send()