sqlite query help

[faustf]

hi guys  i try to do a  query for take a data from db but , not  work properly

this is my  script

Func _Sqlite3_Read()
    Local $hQuery, $sMsg, $aRow

    _SQLite_Startup()
    If @error Then
        MsgBox($MB_SYSTEMMODAL, "SQLite Error", "SQLite3.dll Can't be Loaded!" & @CRLF & @CRLF & _
                "Not FOUND in @SystemDir, @WindowsDir, @ScriptDir, @WorkingDir, @LocalAppDataDir\AutoIt v3\SQLite")
        ; Exit -1
    EndIf
    Local $DB = _SQLite_Open(@ScriptDir & "\WEB-SITE\eBay\eBay.db")
    If @error Then
        MsgBox($MB_SYSTEMMODAL, "SQLite Error", "Can't create a memory Database!")
        ;Exit -1
    EndIf
    ;_SQLite_Query(-1, "(SELECT * FROM  eBayNewItem );",$hQuery)
    _SQLite_Query(-1, "SELECT id FROM eBayNewItem ORDER BY id;", $hQuery) ; the query

    If @error Then
        MsgBox($MB_SYSTEMMODAL, "SQLite Error", _SQLite_ErrMsg(-1))
        ;Exit -1
    EndIf
    While _SQLite_FetchData($hQuery, $aRow) = $SQLITE_OK
        $sMsg &= $aRow[0]
    WEnd
    Return $sMsg
    _SQLite_Close()
    _SQLite_Shutdown()


EndFunc   ;==>_Sqlite3_Read

not return some error but not extract data , anyone can help me?? thankz so much at all

 

[Danyfirex]

Hello. It should work. use some sqlite manager and make the query. 

 

Saludos

[faustf]

yea  its  work , thanks  somuch