is ! reserved?

[mattfaust]

My password  ( !SQLpassword ) is not getting read and entered correctly, why?

thanks

expandcollapse popup

#include <GUIConstantsEx.au3>
#include <ProgressConstants.au3>
#include <WindowsConstants.au3>
#include <EditConstants.au3>
#include <StaticConstants.au3>
#include <Process.au3>




    Local $SQLinstance,$user,$pw, $SaveDir, $progressbar, $button, $wait, $s, $msg, $m

    GUICreate("SQL DB Backup", 300, 140, 300, 200)
    $SQLinstance = GUICtrlCreateEdit("LOCALHOST\MSSQLEXPRESS", 10, 10, 200, 20)
    $user = GUICtrlCreateEdit("SQLusername", 10, 40, 200, 20)
    $pw = GUICtrlCreateEdit("!SQLpassword", 10, 70, 200, 20)
    $progressbar = GUICtrlCreateProgress(10, 100, 200, 20)
    GUICtrlSetColor(-1, 32250); not working with Windows XP Style
    ;$progressbar2 = GUICtrlCreateProgress(10, 40, 200, 20, $PBS_SMOOTH)
    $button = GUICtrlCreateButton("Start", 220, 100, 70, 20)
    $SaveDir = GUICtrlCreateEdit("D:\Backup\SQL" & @CRLF, 10, 120, 200, 20)
    GUISetState()




 While 1
        Switch GUIGetMsg()
            Case $GUI_EVENT_CLOSE
                ExitLoop

            Case $button
                ; Run Notepad with the window maximized.
               ; $iPID = Run("notepad.exe", "", @SW_SHOWMAXIMIZED)

               RunBackup()

        EndSwitch
    WEnd





Func RunBackup()
    $SQLinstance1=GUICtrlRead($SQLinstance)
    $username=GUICtrlRead($user)
    $password= GUICtrlRead($pw)
    $command = "sqlcmd -S "&$SQLinstance1&" -U "&$username&" -P "&$password&" -Q "&'"'&"BACKUP DATABASE testDB TO DISK="&"'"&"C:\temp\Backupsql.bak"&"'"&'"'

    ;RunWait($command)

    $iPID = Run("notepad.exe", "")
    Sleep (1000)
    Send ($command)
    ;exit
    EndFunc

[mikell]

! is reserved in the Send() function -- it means ALT

To send your string raw you must write it like this

Send ($command, 1)

[mattfaust]

so how would I use $command in RunWait, as it doesnt have the raw flag?

[BrewManNH]

What is $password getting set to?

Also, you should be using an input control (GUICtrlCreateInput) instead of an edit control because an edit control can have more than one line by default.

[michaelslamet]

I cant see why RunWait can fail on this. Go and try it, I think it should no issue with ! character

[mattfaust]

$password = !SQLPassword.

it doesnt seem to work but the dos window is closing before I can read the output, it may be another issue.

is there a way I can make the command window stay - or - capture the output, Im reading about StderrRead - but im a bit lost

[michaelslamet]

Try this:

RunWait(@comspec & " /k " & $command)

[mattfaust]

thanks