Sqlite and global-messages-db.sqlite thunderbird

[faustf]

hi guys  why  if i open global-messages-db.sqlite with navicat  i can read  data inside of  them and  when i try to open with autoit 

return me  blanc  table ?

#include <SQLite.au3>
#include <Array.au3>



_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")
    EndIf
Local $hDB = _SQLite_Open("C:\Users\SviluppoGest\Desktop\global-messages-db.sqlite")
If @error Then
        MsgBox($MB_SYSTEMMODAL, "SQLite Error", "Can't create a memory Database!")
EndIf

Local $aRows, $iRows, $iCols,$iRval
$iRval =_SQLite_GetTable2d($hDB, "select c0body,c1subject,c2attachmentNames,c3author,c4recipients from messagesText_content where c1subject = 'Test' AND c3author = 'noreply@spedirecomodo.it';", $aRows, $iRows, $iCols)

;   $iRval = _SQLite_GetTable($hDB, "select c0body,c1subject,c2attachmentNames,c3author,c4recipients from messagesText_content where c1subject = 'Test' AND c3author = 'noreply@spedirecomodo.it';", $aRows, $iRows, $iCols)


_ArrayDisplay($iRows)
for $x = 1 to UBound($aRows)-1
    ;ConsoleWrite($aRows[$x][0]&"-"&$aRows[$x][1]&"-"&$aRows[$x][2]&$aRows[$x][3]&"-"&$aRows[$x][4]&"-"&@CRLF)
    ;Run ( @ScriptDir & '\SumatraPDF.exe -print-to-default ........????
Next

_SQLite_Close($hDB)
_SQLite_Shutdown()

 

[jchd]

Insert error handling code and report which error occurs where.

[faustf]

not  return error

#include <SQLite.au3>
#include <Array.au3>




_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")
    EndIf
Local $hDB = _SQLite_Open("C:\Users\SviluppoGest\Desktop\global-messages-db.sqlite")
If @error Then
        MsgBox($MB_SYSTEMMODAL, "SQLite Error", "Can't create a memory Database!")
EndIf

Local $aRows, $iRows, $iCols,$iRval
$iRval =_SQLite_GetTable2d($hDB, "select c0body,c1subject,c2attachmentNames,c3author,c4recipients from messagesText_content where c1subject = 'Test' AND c3author = 'noreply@spedirecomodo.it';", $aRows, $iRows, $iCols)
If $iRval = $SQLITE_OK Then

    Else
        MsgBox($MB_SYSTEMMODAL, "SQLite Error: " & $iRval, _SQLite_ErrMsg())
    EndIf

;   $iRval = _SQLite_GetTable($hDB, "select c0body,c1subject,c2attachmentNames,c3author,c4recipients from messagesText_content where c1subject = 'Test' AND c3author = 'noreply@spedirecomodo.it';", $aRows, $iRows, $iCols)


_ArrayDisplay($iRows)
for $x = 1 to UBound($aRows)-1
    ;ConsoleWrite($aRows[$x][0]&"-"&$aRows[$x][1]&"-"&$aRows[$x][2]&$aRows[$x][3]&"-"&$aRows[$x][4]&"-"&@CRLF)
    ;Run ( @ScriptDir & '\SumatraPDF.exe -print-to-default ........????
Next

_SQLite_Close($hDB)
_SQLite_Shutdown()

>Running:(3.3.14.5):C:\Program Files\AutoIt3\autoit3.exe "C:\Users\SviluppoGest\Desktop\da-cancellare\thunder.au3"    
--> Press Ctrl+Alt+Break to Restart or Ctrl+Break to Stop
+>17:21:49 AutoIt3.exe ended.rc:0
+>17:21:49 AutoIt3Wrapper Finished.
>Exit code: 0    Time: 1.146

 

Edited May 26, 2020 by faustf

[orbs]

your "error" is here:

_ArrayDisplay($iRows)

 

Edited May 26, 2020 by orbs

[faustf]

1 hour ago, orbs said:

your "error" is here:

no   if  i insert $aRows, appear a table but blank without data, but with navicat i see a data

Edited May 26, 2020 by faustf

[jchd]

There must be an error somewhere.

What gives "select * from messagesText_content"

[rootx]

??? Remove $iRval = and use _SQLite_Display2DResult($aRows) to view output in console.

_SQLite_GetTable2d($hDB, "select c0body,c1subject,c2attachmentNames,c3author,c4recipients from messagesText_content where c1subject = 'Test' AND c3author = 'test@gmail.com';", $aRows, $iRows, $iCols)

_SQLite_Display2DResult($aRows)

Anyway, you can see my solution here

PS: verify my query, because it is not complete, you only have to intercept new emails, otherwise you have duplicates.

CIAO

Edited May 26, 2020 by rootx