squlite thunderbird reading writing

[faustf]

hi guy i wanna creat a app for read whitout thunderbird the message stored in thunderbird

i find in

C:\Users\(your user )\AppData\Roaming\Thunderbird\Profiles\(your default profile)

the file

global-messages-db.sqlite

i read this file for look a structure whit

sql database browser

i see the table (for me interest) is

messagesText_content

i wrote this script (only for understund how connect and read somthing)

#cs ----------------------------------------------------------------------------
AutoIt Version: 3.3.8.1
Author:      myName
Script Function:
Template AutoIt script.
#ce ----------------------------------------------------------------------------
; Script Start - Add your code below here
#include <sqlite.au3>
#include <SQLite.dll.au3>
Local $sSQliteDll
Local $hQuery, $aRow, $sMsg
$sSQliteDll = _SQLite_Startup()
If @error Then
    MsgBox(16, "SQLite Error", "SQLite3.dll Can't be Loaded!")
    Exit -1
EndIf

$FN="C:\Users\stefano\Desktop\New folder (4)\global-messages-db.sqlite"
$Handle=_SQLite_Open($FN=":File:"); This is what is shown in the examples, however, it does not work. (I replaced "Memory" with "File")
;MsgBox(0,"",$Handle)
_SQLite_Query(-1, "SELECT docid FROM messagesText_content ORDER BY 1;", $hQuery)
While _SQLite_FetchData($hQuery, $aRow) = $SQLITE_OK
$sMsg &= $aRow[0]
WEnd
MsgBox(0, "SQLite", "Get Data using a Query : " & $sMsg)
_SQLite_Shutdown()

but give me always in console this error

! SQLite.au3 Error

--> Function: _SQLite_Query

--> Query: SELECT docid FROM messagesText_content ORDER BY 1;

--> Error: no such table: messagesText_content

why ??

[jchd]

Try this way:

#include 
#include 
#include 

_SQLite_Startup()
If @error Then
MsgBox(16, "SQLite Error", "SQLite3.dll Can't be Loaded!")
Exit -1
EndIf

Local $FN = "C:UsersstefanoDesktopNew folder (4)global-messages-db.sqlite"
Local $Handle = _SQLite_Open($FN); open the correct file!
If Not @error Then
Local $aRows, $iNbRows, $iNbCols
_SQLite_GetTable2d($Handle, "SELECT docid FROM messagesText_content;", $aRows, $iNbRows, $iNbCols) ; "order by 1" makes no sense
If Not @error Then
_ArrayDisplay($aRow)
EndIf
_SQLite_Close($Handle)
EndIf
_SQLite_Shutdown()

[faustf]

dont do nothing

no error no gui nothing appear A near the clock (one sec ) and go out

[kylomas]

faustf,

When you actually put in some code to detect the error like this

#include <sqlite.au3>
#include <array.au3>

_SQLite_Startup()
If @error Then
    MsgBox(16, "SQLite Error", "SQLite3.dll Can't be Loaded!")
    Exit -1
EndIf

Local $FN = "C:UsersstefanoDesktopNew folder (4)global-messages-db.sqlite"
Local $Handle = _SQLite_Open($FN); open the correct file!
If Not @error Then
    Local $aRows, $iNbRows, $iNbCols
    _SQLite_GetTable2d($Handle, "SELECT docid FROM messagesText_content;", $aRows, $iNbRows, $iNbCols) ; "order by 1" makes no sense
    If Not @error Then
        _ArrayDisplay($aRows)
    Else
        ConsoleWrite('Error reading table ' & @error & @LF)
    EndIf
    _SQLite_Close($Handle)
else
    ConsoleWrite('error opening DB ' & @error & @LF)
EndIf
_SQLite_Shutdown()

You will see that the DB open is failing.

kylomas