FindString not selecting correct combobox option

[RS_Ana]

I am trying to select a specific option from the combobox. I have tried so many ways but the only way I am able to select combobox is via below code but the issue is it selecting wrong option.

Here is my code:

$databasename = "AutoITDB1"

ControlCommand ('TestSystem', '', '[CLASS:WindowsForm10.Button_1_0_141b42a; INSTANCE:1]', 'FindString', $databasename)

ControlSend('TestSystem', '', '[CLASS:WindowsForm10.Button_1_0_141b42a; INSTANCE:1]', 'select', $databasename)

 

Its not selecting database with name AutoITDB1 from the dropdown but just some random db. Tried almost all solutions with no success. Any help is really appreciated. Attaching screen shot for ref. 

 

[FrancescoDiMuro]

Hi @RS_Ana, and welcome to the AutoIt forum

What are the return values from both functions?

[RS_Ana]

If I do something like this 

$test = ControlCommand ('TestSystem', '', '[CLASS:WindowsForm10.Button_1_0_141b42a; INSTANCE:1]', 'FindString', $databasename)

MsgBox(0, 'DB Name', $test, 10)

I get 0 in the msg box pop up. 

 

I tried with direct database name as well but as usual it just selects some other db . Like this

ControlCommand ('TestSystem', '', '[CLASS:WindowsForm10.Button_1_0_141b42a; INSTANCE:1]', 'FindString', 'AutoITDB1')

Just banging my head all over the place lol....

[RS_Ana]

Resolved the issue with this code:

ControlFocus("Window Title", "", "ControlID")

While 1

Send ("{Down}")

$dbName = ControlCommand ("Window Title", '', "[CLASS:WindowsForm10.Button_1_0_141b42a; INSTANCE:1]")

If $dbName = $databasename

ExitLoop

EndIf

WEnd

[jdelaney]

You need to do the controlcommand selectstring (you are using an invalid option of "select") on the combo box, not on a button.

As a side note, you can easily debug these failures by looking at the @error, to see what the failure reason was

Read about all the options in the help file:

Controlcommand

 

Edited August 9, 2018 by jdelaney

[RS_Ana]

Thnx jdelaney for ur input.

[RS_Ana]

Can any one help, the exact script which is working in windows 2012 is not working in Windows2016 server.

ControlFocus($dbUtilityWindowTitle,"", "[CLASS:WindowsForms10.COMBOBOX.app.0.141b42a_r6_ad1; INSTANCE:1]")
MsgBox(0, "Database Name", $databasename)
Sleep(5000)
While 1
    Send("{Down}")
    Sleep(300)
    $dbName = ControlGetText($dbUtilityWindowTitle,"", "[CLASS:WindowsForms10.COMBOBOX.app.0.141b42a_r6_ad1; INSTANCE:1]")
    MsgBox(0, "Database Name", $dbName)
    Sleep(300)
    If $dbName = $databasename Then
        MsgBox(0, "Database Name", "Provided Database Found")
        ExitLoop
    Else
        MsgBox(0, "Database", "Provided database does not exists.")
        Exit
    EndIf
WEnd
Sleep(1000)
WinActivate($dbUtilityWindowTitle)

The MsgBox I am using is just to debug it. My $databasename is calling correct value but $dbName is showing the default value populated in dropdown which is "Create New database". The Send("{Down}") is not sending down action on combobox and directly else loop is executing and show msgbox "Provided database does not exists".

I am not sure why send down is not working in win 2016 server.

Any help is really appreciated.

[jdelaney]

Send is not a reliable function.  You can make it a bit more reliable by making sure you control is in focus, and your window is active

 

WinActivate

ControlFocus

 

Then you have to take into consideration that autoit might send too quickly for the application to read, or the delay between character sends is too short...which can be modified via

AutoItSetOptions

 

 

Use ControlCommand with 'selectstring'...extremely reliable.

[RS_Ana]

jdelaney I updated the code to:

WinActivate($dbUtilityWindowTitle)
ControlFocus($dbUtilityWindowTitle,"", "[CLASS:WindowsForms10.COMBOBOX.app.0.141b42a_r6_ad1; INSTANCE:1]")
Sleep(3000)
While 1
    Send("{Down}")
    Opt("SendKeyDelay", 1000)
        $dbName = ControlGetText($dbUtilityWindowTitle,"", "[CLASS:WindowsForms10.COMBOBOX.app.0.141b42a_r6_ad1; INSTANCE:1]")
        MsgBox(0, "DB Name from DD", $dbName, 2)
        If $dbName = $databasename Then
            MsgBox(0, "Database Name", "Provided Database Found")
            ExitLoop

        EndIf
WEnd

And the issue is First down key happens and moves to first entry of dropdown and I get the DB name as first entry of db dropdown and after that down is not happening because the same MsgBox comes and goes after 2 sec with only forst combobox entry. Its not going to 3, 4, 5.. combo box entries until I click ok from the Msg Box (before 2 sec). If I click Ok on MsgBox it goes to second combo box option again click Ok of MsgBox and it will go next.

I have no idea y this is happening.

I tried with CommandControl but no success.

[jdelaney]

I'm not going to help you hack a send...try with the controlcommand, or wait for someone who will help you with the send.

Start by getting the control as a handle, and verifying that:

$hControl = ControlGetHandle($dbUtilityWindowTitle,"", "[CLASS:WindowsForms10.COMBOBOX.app.0.141b42a_r6_ad1; INSTANCE:1]")

MsgBox(1,1,$hControl)

If that message box displays the same handle for the control, as you see in the auto it spy tool, then do this:

ControlCommand($dbUtilityWindowTitle,"", $hControl, "SelectString", $databasename)

 

If the message box doesn't return the correct handle, you need to find a better way to find your control.

 

I know it's a personal preference not to use send (except as a very last resort), but take some advice from me...if you want a script that will work greater than 80-90% of the time, you'll go  with the controlcommand route.

Edited August 11, 2018 by jdelaney

[RS_Ana]

jdelaney the sol you suggested didn't work . So I modified the code as :

WinWaitActive($dbUtilityWindowTitle, "", 10)
ControlFocus($dbUtilityWindowTitle,"", "[CLASS:WindowsForms10.COMBOBOX.app.0.141b42a_r6_ad1; INSTANCE:1]")
Sleep(3000)
ControlClick($dbUtilityWindowTitle, "", "[CLASS:WindowsForms10.COMBOBOX.app.0.141b42a_r6_ad1; INSTANCE:1]")
Local $hControl = ControlGetHandle($dbUtilityWindowTitle,"", "[CLASS:WindowsForms10.COMBOBOX.app.0.141b42a_r6_ad1; INSTANCE:1]")
ControlCommand($dbUtilityWindowTitle,"", $hControl, "SelectString", $databasename)
;Sleep(5000)
;MsgBox(1,1,"Success",10)
ControlCommand($dbUtilityWindowTitle,"", "[CLASS:WindowsForms10.COMBOBOX.app.0.141b42a_r6_ad1; INSTANCE:1]", "SetCurrentSelection", $databasename)
Sleep(2000)
WinActivate($dbUtilityWindowTitle)
$warningMgsRef = ControlGetHandle($dbUtilityWindowTitle,"", "[CLASS:WindowsForms10.STATIC.app.0.141b42a_r6_ad1; INSTANCE:5]")
Switch $warningMgsRef
    Case $warningMgsRef
        MsgBox(0, "Database", "Database overwrite is called", 5)
        ControlClick("GVE - Database Utility","", "[CLASS:WindowsForms10.BUTTON.app.0.141b42a_r6_ad1; INSTANCE:6]")
    Case Else
        MsgBox(0, "Database", "No data found", 5)
EndSwitch

 

ControlClick(line 4) is clicking on the dropdown but after that    MsgBox(0, "Database", "Database overwrite is called", 5) is executing which will happen only if database is found  but the dropdown remains selected to default option which is "Select a database" .

Any solution for my prob?

 

[Danyfirex]

Hello. You can do it by Index Something like this:

#include <GuiComboBoxEx.au3>

Local $hControl=ControlGetHandle("GVE - Database Utility","","WindowsForms10.BUTTON.app.0.141b42a_r6_ad16")
_GUICtrlComboBoxEx_SetCurSel ( $hControl ,1)
 

 

Saludos