$query_name="SELECT * from employers WHERE Full_Name like '%"&GUICtrlRead($searchinput)&"%'"$exe_name=_Query($SQLOBJ,$query_name)with$exe_namewhileNOT.EOFIf.Field('Full_Name').value<>$searchinputThen;Check if $searchinput match Database recordGUICtrlSetData($IDLB,.Fields('UID').value);Set or display the result at $nameinputGUICtrlSetData($nameinput,.Fields('Full_Name').value);Set or display the result at $nameinputGUICtrlSetData($depinput,.Fields('Department').value);Set or display the result at $depinputGUICtrlSetData($reportinput,.Fields('Manager').value);Set or display the result at $reportinputGUICtrlSetData($DOHinput,.Fields('DateOfHire').value);Set or display the result at $DOHinputGUICtrlSetData($Phoneinput,.Fields('Work_Phone').value);Set or display the result at $PhoneinputGUICtrlSetData($Shiftinput,.Fields('Shift').value);Set or display the result at $ShiftinputReturnEndIfReturnWEndEndWith

Now I'm on 64-bit OS. I compiled to 86x and thats the error I have been getting. Compiling to 64x, it works fine again. I took the script and work on a 32bit OS and it's not taking the code. Is this normal or is mysql.au3 UDF build to work on 64bit os only?

Edited May 7, 2014 by asianqueen

Msgbox(0, "Hate", "Just hate it when I post a question and find my own answer after a couple tries. But if I don't post the question, I can't seem to resolve it at all.")

Share this post

Link to post

Share on other sites

Queener 1

Bump to close this thread. I found a work around. Instead of using mysql.au3, I went with EzMySQL. Most of the codes are done through sql instead of using autoit commands to check for exists records etc....

For example:

Local$query1="SELECT * from employers WHERE Full_Name like '%"&GUICtrlRead($searchinput)&"%'"IfNot_EzMySQL_Query($query1)Then
ClearAll()Else;Execute the queryFor$i=1To_EzMySql_Rows()Step1$a1Row=_EzMySql_FetchData();MsgBox (0, "Full_Name", $a1Row[1]);_ArrayDisplay($a1Row, "Result: " & $i);Output it to textboxGUICtrlSetData($nameinput,$a1Row[1]);Set or display the result at $nameinputGUICtrlSetData($depinput,$a1Row[2]);Set or display the result at $nameinputGUICtrlSetData($reportinput,$a1Row[3]);Set or display the result at $nameinputGUICtrlSetData($DOHinput,$a1Row[4]);Set or display the result at $nameinputGUICtrlSetData($Phoneinput,$a1Row[5]);Set or display the result at $nameinputGUICtrlSetData($Shiftinput,$a1Row[6]);Set or display the result at $nameinputGUICtrlSetData($IDLB,$a1Row[0]);Set or display the result at $nameinputNextReturnEndIf