how to connect file .sqlite

[supperfake]

Hello guys

I have a problem with conneting sqlite. This is my code

    _SQLite_Startup()
    Local $DB_1=_SQLite_Open("C:\abc\myfile.sqlite")
    if IsObj($DB_1) Then MsgBox(0,0,0)     
    Local $hQuery,$aRow
    _SQLite_Query($DB_1,"SELECT id FROM product;", $hQuery)
    _SQLite_FetchData($hQuery, $aRow)
    MsgBox(0,0,Ubound($aRow))

 

And it return $aRow=null. No element is in array $aRow.

Where was I wrong? 

[FrancescoDiMuro]

5 minutes ago, supperfake said:

Where was I wrong? 

To see this, there is a mystic and ancent thing called "Debugging" or "Error handling"

_SQLite_FetchData($hQuery, $aRow)
If @error Then
    ConsoleWrite("There is an errore here! Error: " & @error & @CRLF)
Else
    ; Continue with the script...
EndIf

So, you can see what is going on when you call the function

[supperfake]

Thank FrancescoDiMuro

I have fixed my code

_SQLite_Startup ("Sqlite3.dll", False, 1)
    Local $DB_1=_SQLite_Open(path_to_sqlite)
    If _SQLite_Query($DB_1,"SELECT * FROM moz_places;", $hQuery)==$SQLITE_OK Then
        While _SQLite_FetchData($hQuery, $aRow, False, False) = $SQLITE_OK ; Read Out the next Row
        ConsoleWrite( $aRow[0]  & @CRLF)
        WEnd
     Else
           //do something
    EndIf

And Done ....... 

 

Edited July 26, 2018 by supperfake

[FrancescoDiMuro]

@supperfake

Happy to have helped!

[jchd]

@supperfake

You'd rather use higher level SQlite functions, like _SQLite_GetTable2D and friends.