Basic SQLite Viewer

[LurchMan]

Hey Everyone -

I've been doing a lot of work with SQLite here lately so I decided to build my own viewer - Its very basic but functional. If anyone has any ideas on how I could improve it or something that should be done a different way, please let me know. Thanks for taking a look at this!

Database Demo:

#include <sqlite.au3>
#include <SQLite.dll.au3>
#include <file.au3>

_FileCreate ("C:\demo.db")
$hDll = _SQLite_Startup ()
$hDB = _SQLite_Open ("C:\demo.db")
_SQLite_Exec ($hDB, "CREATE TABLE table1 (col1, col2, col3, col4);")
_SQLite_Exec ($hDB, "INSERT INTO table1 VALUES ('hello','world','im','table');")
_SQLite_Exec ($hDB, "INSERT INTO table1 VALUES ('home','how','are','table');")
_SQLite_Exec ($hDB, "INSERT INTO table1 VALUES ('you','?','?','table');")
_SQLite_Exec ($hDB, "CREATE TABLE table2 (col1, col2, col3);")
_SQLite_Exec ($hDB, "INSERT INTO table2 VALUES ('hello','world','im');")
_SQLite_Exec ($hDB, "INSERT INTO table2 VALUES ('home','how','are');")
_SQLite_Exec ($hDB, "INSERT INTO table2 VALUES ('you','?','?');")
_SQLite_Close ($hDB)
_SQLite_Shutdown ()

SQLite Viewer.au3

[dmob]

>Running:(3.3.6.1):C:\Program Files\AutoIt3\autoit3.exe "D:\Scripts\SQLite Viewer.au3"

D:\Scripts\SQLite Viewer.au3 (201) : ==> Array variable has incorrect number of subscripts or subscript dimension range exceeded.:

_GUICtrlListView_AddSubItem($hListView, $iCnt, $aData[$n + $i], $i)

_GUICtrlListView_AddSubItem($hListView, $iCnt, ^ ERROR

[LurchMan]

What does your database look like?

[dmob]

See attach