SQL - Search

[Queener]

I created 2 input boxes and 1 button.

$searchinput = textbox that will be used to search

$nameinput = textbox that will be displaying the result. (I'm not using a label because I'm going to impliment it later on to modify data and save records)

$searchb1 = the button to press when search is ready.

Goal: type an employee name on the searchinput and press the search button. If employee name exist, show it on the nameinput textbox.

Func SearchUser()
$query_name = "SELECT * from employers where Full_Name = '%" & $searchinput & "%'"
$exe_name = _Query($SQLOBJ, $query_name)

with $exe_name
    while NOT .EOF
GUICtrlSetData($nameinput, .Fields('Full_Name').value)
.MoveNext
WEnd
EndWith
EndFunc

I tested with the msgbox and it works fine.

Can someone show me the official way on how to get this to work with the textbox? I'm using the sql.au3.

thanks,

Edited May 6, 2014 by asianqueen

[mikell]

This SQL.au3 is obsolete since AutoIt3 has now the SQLite.au3 file provided in the install

[argumentum]

I created 2 input boxes and 1 button.

$searchinput = textbox that will be used to search

$nameinput = textbox that will be displaying the result. (I'm not using a label because I'm going to impliment it later on to modify data and save records)

$searchb1 = the button to press when search is ready.

Goal: type an employee name on the searchinput and press the search button. If employee name exist, show it on the nameinput textbox.

Func SearchUser()
$query_name = "SELECT * from employers where Full_Name = '%" & $searchinput & "%'"
$exe_name = _Query($SQLOBJ, $query_name)

with $exe_name
    while NOT .EOF
GUICtrlSetData($nameinput, .Fields('Full_Name').value)
.MoveNext
WEnd
EndWith
EndFunc

I tested with the msgbox and it works fine.

Can someone show me the official way on how to get this to work with the textbox? I'm using the sql.au3.

thanks,

maybe if .Fields('Full_Name').value <> "" then GUICtrlSetData($nameinput, .Fields('Full_Name').value)

[Queener]

maybe if .Fields('Full_Name').value <> "" then GUICtrlSetData($nameinput, .Fields('Full_Name').value)

I'm seeing result, but wrong result. Say I search 'John', it came out Kathy. Any search comes out the same result Kathy.

Nevermind, I got it...

$query_name = "SELECT * from employers WHERE Full_Name like '%" & GUICtrlRead($searchinput) & "%'"
$exe_name = _Query($SQLOBJ, $query_name)

 

Forgot to add GUICtrlRead

Edited May 6, 2014 by asianqueen