faustf

sqlite query help

3 posts in this topic

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

 

Share this post


Link to post
Share on other sites



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

 

Saludos

1 person likes this

Share this post


Link to post
Share on other sites

yea  its  work , thanks  somuch  :)

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now