Unable to click element in Teradata SQL Assistant

[Luli]

I need the script to launch a connection with the Teradata SQL Assistant and to do so it must be able to click on the area I marked in red.

Even the debug mode isn't helping because it says that everything is executed successfully but the new window is not opening. 

A copy of my script:

ConsoleWrite("Waiting for Teradata SQL Assistant window..." & @CRLF)
Local $hWnd = WinWait("Teradata SQL Assistant", "", 10)

; Check if the window handle was obtained successfully
If $hWnd Then
    ConsoleWrite("Teradata SQL Assistant window found." & @CRLF)

    ; Get the handle of the main window
    $hWnd = WinGetHandle("Teradata SQL Assistant")

    ; Check if the main window handle is valid
    If $hWnd Then
        ConsoleWrite("Activating Teradata SQL Assistant window..." & @CRLF)
        ; Activate the Teradata SQL Assistant window
        WinActivate($hWnd)
        WinWaitActive($hWnd)

        ; Find and click the toolbar area to start a connection
        ConsoleWrite("Finding toolbar area..." & @CRLF)
        Local $hToolbar = ControlGetHandle($hWnd, "", "[NAME:_MainWnd_Toolbars_Dock_Area_Top]")

        ; Check if the toolbar control handle was obtained successfully
        If $hToolbar Then
            ConsoleWrite("Toolbar area found. Clicking..." & @CRLF)
            ; Click on the toolbar area (adjust the coordinates as needed)
            ControlClick($hWnd, "", $hToolbar, "left", 1, 25, 65)
        Else
            ConsoleWrite("Error: Failed to find the toolbar area." & @CRLF)
            MsgBox(16, "Error", "Failed to find the toolbar area.")
        EndIf
    Else
        ConsoleWrite("Error: Failed to get the handle of the main window." & @CRLF)
        MsgBox(16, "Error", "Failed to get the handle of the main window.")
    EndIf
Else
    ConsoleWrite("Error: Teradata SQL Assistant window not found." & @CRLF)
    MsgBox(16, "Error", "Teradata SQL Assistant window not found.")
EndIf

[Andreik]

Try this:

$hWin = WinWait('Teradata SQL Assistant')
If IsHWnd($hWin) Then ControlClick($hWin, '', '[REGEXPCLASS:(?i)WindowsForms\d+\.Window\.\d+\.app\.\d+\.[a-z0-9_]+_ad1; INSTANCE:30]')

 

Edited April 22, 2024 by Andreik

[Luli]

Still not clicking. 😔

[Nine]

1- make sure you are on the same CPU architecture (x86 or x64) : script and teradata

2- try using #RequireAdmin

3- ensure teradata has focus

4- try with UIAutomation

5- resort to use MouseClick (no big deal if [ACTIVE])

Edited April 23, 2024 by Nine

[water]

You are sure that automating the Teradata SQL Assistant GUI is the best way to do what you want to do (btw. what do you want to achieve with your script)?
You can use ODBC from AutoIt to access the database etc. etc.