Personally, I use my own wrapper (attached) with Greg Obleshchuk's
AGS_SQLite.dll. It is very simple to use (it will generate the SQL code for
you):
Dim db as ADOSQLite
Set db = new ADOSQLite
db.Connect "database.db"
db.Table = "mytable"
db.Action = ActionSelect
db.Sort = "id"
db.Where = "id < 100"
db.Exec
If Not db.Err Then
do while not db.EOF
debug.print db.field("id")
db.MoveNext
Loop
End if
Of course this runs "in-memory" so if this is a concern for you, then try to
narrow down your selects.
Cheers!
Chris
> -----Original Message-----
> From: Raymond Irving [mailto:[EMAIL PROTECTED]
> Sent: 14 May 2004 17:50
> To: [EMAIL PROTECTED]
> Subject: Re: [sqlite] sqlite with Visual Basic
>
>
> I use SQLite ODBC with ADO to access databases from VB. It
> works like a charm.
>
> http://www.ch-werner.de/sqliteodbc/
>
> __
> Raymond Irving
>
>
> Jérôme_VERITE <[EMAIL PROTECTED]> wrote:
> I use this wrapper and to simplify again the code, I created
> littles classes which are very simple and look like the DAO
> classes. It permits to transform Simply a VB application
> using DAO to SQLITE
>
> Jérôme
>
> -----Message d'origine-----
> De : Steve O'Hara [mailto:[EMAIL PROTECTED]
> Envoyé : vendredi 14 mai 2004 10:35
> À : Jalil Vaidya; Carlos Garces; [EMAIL PROTECTED]
> Objet : RE: [sqlite] sqlite with Visual Basic
>
>
> Here's the SQLite wrapper for VB from the Yahoo groups........
>
> Steve
>
> -----Original Message-----
> From: Jalil Vaidya [mailto:[EMAIL PROTECTED]
> Sent: 14 May 2004 02:13
> To: Carlos Garces; [EMAIL PROTECTED]
> Subject: Re: [sqlite] sqlite with Visual Basic
>
>
> There is a VBWrapper.zip in the old SQLite yahoo
> group's file section. The archive contains wrapper
> over the SQLite API so that it can be used from VB.
> The API declarations for VB are also in the archieve.
> Get it from here:
>
> http://f4.grp.yahoofs.com/v1/EBqkQKgMWwt8clzVakFnZ6GAGVancQ9q-
> 4gKNXEFX9QQmKI
> vHaVaTJ9rp1fz-XHaFxRIq46etnp1v_WDUrQPABeSNps/VB%20Wrapper
>
> If you cannot download from the link above then you
> will have to join the group to get it.
>
> HTH,
>
> Jalil Vaidya
>
> Disclaimer: I have never used this wrapper myself.
>
> --- Carlos Garces wrote:
> > Hi!
> > I can use SQLLite with Visual Basic without using
> > other external DLL
> > Any sample of using sqlite.dll API?
> >
> > Thanks
> > Carlos Garcis
>
>
> =====
> 01001010
> 01100001
> 01101100
> 01101001
> 01101100
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Movies - Buy advance tickets for 'Shrek 2'
> http://movies.yahoo.com/showtimes/movie?mid=1808405861
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
> > ATTACHMENT part 2 application/x-zip-compressed name=VBSQLite.zip
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.684 / Virus Database: 446 - Release Date: 13/05/2004
>
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.686 / Virus Database: 447 - Release Date: 14/05/2004
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
