Re: [sqlite] Visual Basic Programming to SQlite
Depends on what version of VB and what type of data access underpinnings you're using. If it's ADO.NET, you'll want to use the free open-source SQLite ADO.NET provider from http://sqlite.phxsoftware.com Robert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Charest Sent: Friday, October 03, 2008 4:54 PM To: sqlite-users@sqlite.org Subject: [sqlite] Visual Basic Programming to SQlite I am a Visual Basic programmer who would like to port the Access Database over to SQlite. Is there any documentation on how to use this database with Visual Basic? I am difficulty finding any documentation on it. Thanks ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Visual Basic Programming to SQlite
Steven Charest <[EMAIL PROTECTED]> writes: > > I am a Visual Basic programmer who would like to port the Access Database > over to SQlite. Is there any documentation on how to use this database with > Visual Basic? I am difficulty finding any documentation on it. You can use my ADO-like wrapper-classes to work against the SQLite-engine. The toolset-binaries are in the Public Domain and can be downloaded here (including the source for many VB6-Demo-Projects): http://www.datenhaus.de/Downloads/dhRichClientDemo.zip The project in the subfolder ..\Src_SQLiteDemo\ compares ADO/JET and SQLite-Performance and is based on the original NWind.mdb, which is converted (a conversion-class is included) to a NWind.db automatically on first run (including the Indexes and Views). Regards, Olaf Schmidt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Visual Basic Programming to SQlite
Dim Records
Dim Database
dim Recs
AddObject "newObjects.sqlite3.dbutf8", "Db"
set Database = Db
'Open the database
On Error resume next
If DataBase.Open(Get_Database_Name) Then
DataBase.AutoType = True
DataBase.TypeInfoLevel = 4
Else
MsgBox "ERROR ON OPEN OF DATABASE: " & DataBase.lastError
Bye
End If
On Error Goto 0
On Error resume next
Set Records= Database.Execute("Select * from tablea")
On Error Goto 0
Recs = 1
While Recs <= Records.Count
DoEvents
blah balh
Recs = Recs + 1
wend
Set Records = Nothing
DataBase.Close
Set DataBase = Nothing
--- On Fri, 10/3/08, Steven Charest <[EMAIL PROTECTED]> wrote:
> From: Steven Charest <[EMAIL PROTECTED]>
> Subject: [sqlite] Visual Basic Programming to SQlite
> To: sqlite-users@sqlite.org
> Date: Friday, October 3, 2008, 7:53 PM
> I am a Visual Basic programmer who would like to port the
> Access Database
> over to SQlite. Is there any documentation on how to use
> this database with
> Visual Basic? I am difficulty finding any documentation on
> it.
>
>
>
> Thanks
>
>
>
>
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Visual Basic Programming to SQlite
I am a Visual Basic programmer who would like to port the Access Database over to SQlite. Is there any documentation on how to use this database with Visual Basic? I am difficulty finding any documentation on it. Thanks ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
