SQL Array Fehler

  • Hallo Leute
    ich beschäftige mich erst seit kurzem mit SQL...
    wollte mir selbst eine Viren Datenbank erstellen.
    Mein Versuch:

    Spoiler anzeigen
    [autoit]

    #include <GUIConstants.au3>
    #include <EditConstants.au3>
    #include <SQLite.au3>
    #include <SQLite.dll.au3>

    [/autoit] [autoit][/autoit] [autoit][/autoit] [autoit]

    #Region ### START Koda GUI section ### Form=
    $Form1 = GUICreate("AAV", 223, 359, 267, 119)

    [/autoit] [autoit][/autoit] [autoit][/autoit] [autoit]

    $lname = GUICtrlCreateLabel("Name:", 8, 48, 48, 17)
    $iname = GUICtrlCreateInput("", 64, 48, 145, 21)
    $ltype = GUICtrlCreateLabel("Type:", 8, 88, 45, 17)
    $itype = GUICtrlCreateInput("Malware", 64, 88, 145, 21)
    $imd5 = GUICtrlCreateInput("", 8, 128, 145, 21)

    [/autoit] [autoit][/autoit] [autoit]

    $bchoose = GUICtrlCreateButton("Choose File",8,168,145,21)
    $bload = GUICtrlCreateButton("Load",8,198,145,21)

    [/autoit] [autoit][/autoit] [autoit][/autoit] [autoit]

    $badd = GUICtrlCreateButton("Add", 48, 312, 75, 25, 0)
    $bdel = GUICtrlCreateButton("Delete", 128, 312, 75, 25, 0)
    GUISetState(@SW_SHOW)
    #EndRegion ### END Koda GUI section ###

    [/autoit] [autoit][/autoit] [autoit]

    _SQLite_Startup()
    If NOT FileExists("md5.aav") Then
    $dbn=_SQLite_Open("md5.aav")
    _SQLite_Exec($dbn,"CREATE TABLE datas (md5,type,name);")
    Else
    $dbn=_SQLite_Open("md5.aav")
    EndIf

    [/autoit] [autoit][/autoit] [autoit][/autoit] [autoit]

    While 1
    $nMsg = GUIGetMsg()
    Switch $nMsg
    Case $GUI_EVENT_CLOSE
    progend()
    Case $badd
    IF GUICtrlRead($iname) == "" Then
    MsgBox(0,"ERORR","Empty name!")
    Else
    dataadd(GUICtrlRead($imd5))
    EndIf
    Case $bdel
    datadel(GUICtrlRead($imd5))
    Case $bload
    dataquery(GUICtrlRead($imd5))
    EndSwitch
    WEnd

    [/autoit] [autoit][/autoit] [autoit]

    Func progend()
    _SQLite_Close()
    _SQLite_Shutdown()
    Exit
    EndFunc

    [/autoit] [autoit][/autoit] [autoit][/autoit] [autoit][/autoit] [autoit]

    Func dataadd($id)
    Local $retarr
    $str1 = GUICtrlRead($iname)
    $str2 = GUICtrlRead($itype)
    _SQLite_QuerySingleRow($dbn,"SELECT id FROM datas WHERE md5='"&$id&"'",$retarr)
    If $retarr[0] <> "" Then
    _SQLite_Exec($dbn,"UPDATE datas SET name='"&$str1&"', type='"&$str2&"' WHERE md5='"&$id&"'")
    Else
    _SQLite_Exec($dbn,"INSERT INTO datas (md5,type,name) VALUES ('"&$id&"','"&$str1&"','"&$str2&"');")
    EndIf
    EndFunc

    [/autoit] [autoit][/autoit] [autoit][/autoit] [autoit]

    Func dataquery($id)
    GUICtrlSetData($iname,"")
    GUICtrlSetData($itype,"")
    Local $retarr
    If _SQLite_QuerySingleRow($dbn,"SELECT * FROM datas WHERE md5='"&$id&"'",$retarr) == $SQLITE_OK Then
    If $retarr[0] == "" Then
    ;MsgBox(0,"ERROR","Query error!")
    Else
    GUICtrlSetData($iname,$retarr[1])
    GUICtrlSetData($itype,$retarr[2])
    EndIf
    EndIf
    EndFunc

    [/autoit] [autoit][/autoit] [autoit]

    Func datadel($id)
    Local $retarr
    GUICtrlSetData($iname,"")
    GUICtrlSetData($itype,"")
    _SQLite_QuerySingleRow($dbn,"SELECT id FROM datas WHERE md5='"&$id&"'",$retarr)
    If $retarr[0] <> "" Then
    _SQLite_Exec($dbn,"DELETE FROM datas WHERE md5='"&$id&"'")
    EndIf
    EndFunc

    [/autoit]


    Fehler:

    Zitat

    md5_hash.au3 (66) : ==> Subscript used with non-Array variable.:
    If $retarr[0] <> "" Then
    If $retarr^ ERROR

    Danke mal im Voraus

    mfg. Andi

  • ahh verflucht....
    xD
    habs jetz gefunden

    _SQLite_QuerySingleRow($dbn,"SELECT md5 FROM datas WHERE md5='"&$id&"'",$retarr)