Hello,
I'm working on my first attempt to use SQLite with VB6
for a simple invoicing app, what I'm using is the AGS
sqlite.dll for VB, but I found the sample codes inside
the package is too simple, say, it didn't mentioned about
the structure of the TableArray variable.
And I also don't know if I can access the table with recordset.
All I can do is to access the database/tables by it's built-in
functions, like this:
myDB = "C:\invoice.db"
DB_Handle = sqlite_open(myDB, 0, strErrMsg)
SQL = "SELECT company_name FROM customer"
TableArray = ags_sqlite_get_table(DB_Handle, SQL, strErrMsg)
x = ags_number_of_rows_from_last_call()
For i = 1 To x
frmInvoice.comboTo.AddItem TableArray(i, 0)
Next 'i
sqlite_close DB_Handle
I've tried to browse around SQLite's homepage, but cannot find
any related information.
Any idea ?
Thanks a lot !
Kelvin
>> Stay informed about: SQLite on VB6