Sign in to follow this  
Followers 0
LurchMan

Basic SQLite Viewer

4 posts in this topic

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


Dating a girl is just like writing software. Everything's going to work just fine in the testing lab (dating), but as soon as you have contract with a customer (marriage), then your program (life) is going to be facing new situations you never expected. You'll be forced to patch the code (admit you're wrong) and then the code (wife) will just end up all bloated and unmaintainable in the end.

Share this post


Link to post
Share on other sites



>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

Share this post


Link to post
Share on other sites

What does your database look like?


Dating a girl is just like writing software. Everything's going to work just fine in the testing lab (dating), but as soon as you have contract with a customer (marriage), then your program (life) is going to be facing new situations you never expected. You'll be forced to patch the code (admit you're wrong) and then the code (wife) will just end up all bloated and unmaintainable in the end.

Share this post


Link to post
Share on other sites

See attach

post-35502-12799751839714_thumb.jpg

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
Sign in to follow this  
Followers 0