Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

SQLite on VB6

 
   Database Help (Home) -> Visual Basic RSS
Next:  Backup and restore feature on VB6 application  
Author Message
Kelvin

External


Since: Jun 09, 2004
Posts: 1



(Msg. 1) Posted: Thu Jun 10, 2004 1:08 am
Post subject: SQLite on VB6
Archived from groups: microsoft>public>vb>database (more info?)

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 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
sql query returns in wrong format - Hi, Hope someone can help me with this. I have MS SQL 2000 database where i have Table "PriceList" and there a column "Pricemk" wich is data type "money". All data in this column is in form "10001,35". So why when...

arrays - is there a way to concatenate the contents of an array (looping through the array) and storing each item in a comma delimited string? Thanks!

DataReport PageBreak - Hi everyone, I would like to know how to force pagebreak in a datareport for example after 5 records printed. Thank you all

Possible Use of a Cursor - I have a complex query that I hope I can explain it well enough for everyone to understand. I have a table that contains information for work instructions. Contained in the table are "MACHINE_PROC" these are groupings of machining processes....

Scroll Bars - Is there a way to find the size of scrollbars on a system using Visual Basic 6.0? I know how to look and change them on the display properties, but I don't know how to access that information from within Visual Basic.
   Database Help (Home) -> Visual Basic All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]