Custom Query

Title: MySQL UDF functions Filename: MySQL.au3 Description: A collection of functions for interacting with MySQL Author: cdkid <cdkid@…> Version: 1.6

would be really nice to have something like this one, because this on (on the forum) is not in development anymore, maybe update this one?

The function _GUICtrlComboBoxEx_GetEditText does not give the inputs content, when called on a comboboxEx with the default style ($CBS_DROPDOWN $WS_VSCROLL). It always returns "".

code from autoit documentation with some changes:

#include <Debug.au3>
#include <GuiComboBoxEx.au3>
#include <GuiImageList.au3>
#include <GuiConstantsEx.au3>

Opt('MustDeclareVars', 1)

$Debug_CB = True ; Check ClassName being passed to ComboBox/ComboBoxEx functions, set to True and use a handle to another control to see it work
ClipPut(_DebugBugReportEnv()) ; my Environment = 3.3.0.0 under  WIN_VISTA/Service Pack 2 X64
_Main()

Func _Main()
	Local $hGUI, $hImage, $hCombo
	
	; Create GUI
	$hGUI = GUICreate("ComboBoxEx Get Edit Text", 400, 300)
	$hCombo = _GUICtrlComboBoxEx_Create ($hGUI, "", 2, 2, 394, 100)
	GUISetState()

	$hImage = _GUIImageList_Create (16, 16, 5, 3)
	_GUIImageList_AddIcon ($hImage, @SystemDir & "\shell32.dll", 110)
	_GUIImageList_AddIcon ($hImage, @SystemDir & "\shell32.dll", 131)
	_GUIImageList_AddIcon ($hImage, @SystemDir & "\shell32.dll", 165)
	_GUIImageList_AddIcon ($hImage, @SystemDir & "\shell32.dll", 168)
	_GUIImageList_AddIcon ($hImage, @SystemDir & "\shell32.dll", 137)
	_GUIImageList_AddIcon ($hImage, @SystemDir & "\shell32.dll", 146)
	_GUIImageList_Add ($hImage, _GUICtrlComboBoxEx_CreateSolidBitMap ($hCombo, 0xFF0000, 16, 16))
	_GUIImageList_Add ($hImage, _GUICtrlComboBoxEx_CreateSolidBitMap ($hCombo, 0x00FF00, 16, 16))
	_GUIImageList_Add ($hImage, _GUICtrlComboBoxEx_CreateSolidBitMap ($hCombo, 0x0000FF, 16, 16))
	_GUICtrlComboBoxEx_SetImageList ($hCombo, $hImage)

	For $x = 0 To 8
		_GUICtrlComboBoxEx_AddString ($hCombo, StringFormat("%03d : Random string", Random(1, 100, 1)), $x, $x)
	Next
	
	; Set Edit Text
	_GUICtrlComboBoxEx_SetEditText ($hCombo, StringFormat("%03d : Random string", Random(1, 100, 1)))
	
	; Get Edit Text
	MsgBox(4160, "Information", "Edit Text: " & _GUICtrlComboBoxEx_GetEditText ($hCombo))
	
	Do
	; Get Edit Text ond dirfferent selections
	MsgBox(4160, "Information", "Edit Text: " & _GUICtrlComboBoxEx_GetEditText ($hCombo))
	Until GUIGetMsg() = $GUI_EVENT_CLOSE
EndFunc   ;==>_Main

; Environment = 3.3.0.0 under WIN_VISTA/Service Pack 2 X64

When closing an Excel workbook with the _ExcelBookClose function, the workbook stays open in the background when the AutoIt3 script is still running. You can only solve this by Ctrl-Alt-Del and closing EXCEL.EXE. Downside during script operation is that the Excel file cannot be opened. Tested on .xls files.

Try opening the file during the last sleep function, it will not work, only when AutoIt3 is terminated:

#include <Excel.au3>

Local $oExcel = _ExcelBookOpen(test.xls", 1)
Sleep(5000)
_ExcelBookClose($oExcel,0,0)
Sleep(10000)