Re: [sqlite] Hello I am a newbie : for SQLite : Create db : VB6
Just open the file. palmer ristevski wrote: > I am new to this type of Forum.Here is my question : My development platform > is VB6. I am using "SQLitePlus COM-DLL" from ez-tools.com.They have code to > access and query an existing ".db" file, but I wish to know how to make a > function call to create new SQLite database files on harddisk.How would you > do this using VB6?What is the function call that you would have to make.I > know how to do this with SQLite at the command line, and I could use VB6 to > execute these commands at the command line, but I want a more direct way to > create new database files.Hope someone can help me out. > Pablopico> Date: Tue, 29 Apr 2008 20:32:32 +0200> From: [EMAIL PROTECTED]> > To: [EMAIL PROTECTED]> Subject: Re: Hello I am a newbie> > Hello Pablopico,> > > i am sorry, but i can not answer your question. I do not know VB. How > did > you find my eMail - address anyway?> > To join the sqlite mailing list, > visit> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > and > follow the instructions. Then post your questions by mailing them to> > > sqlite-users@sqlite.org> > Good luck,> Martin> > [EMAIL PROTECTED] wrote:> > > I am new to this type of Forum.> > I don't know how one is supposed to post > to this forum.> > I don't see a "POST" button on this site.> > Based on email > information I got from SQLite users, is this> > all done via 'email > posting'?> >> > Anyways, I also have a question.> > My development platform > is VB6. I am using "SQLitePlus COM-DLL" from > > ez-tools.com.> > They have > code to access and query an existing ".db" file, but I wish to know how to make a function call to create new SQLite database files on harddisk.> > How would you do this using VB6?> > What is the function call that you would have to make.> > I know how to do this with SQLite at the command line, and I could use VB6 to execute these commands at the command line, but I want a more direct way to create new database files.> >> > Hope you can help me out.> >> > Pablopico> >> >> > > > _ > Back to work after baby–how do you know when you’re ready? > http://lifestyle.msn.com/familyandparenting/articleNW.aspx?cp-documentid=5797498&ocid=T067MSN40A0701A > ___ > 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] Hello I am a newbie : for SQLite : Create db : VB6
Hello. I happened to see this thread (I'm EzTools suppport). The Sqlite open function automatically creates a new file if the file doens't exist. SqlitePlus does the same thing (since it just passes through to Sqlite). However, I have added an additional, optional parameter that will cause the SqliteDb.Open method to fail if the file doesn't exist. But it is false by default, so calling open with a filename that doesn't exist should create the file. Maybe its being created in a different folder than your .exe? Its possible its in a place you don't expect if you aren't passing a full path. Anyway, here is a good way to call SqliteDb.Open from a VB app: db.Open App.Path & "my_database.db", 0, false Let me know via my eddress if you still have problems ([EMAIL PROTECTED]). cheers -brett Quoting palmer ristevski <[EMAIL PROTECTED]>: > > That is Great OLAF > That is all that I am looking for. > I just want to be able to create new files, > then create tables and populate them and > do simple queries. > If I can do that with your stuff, that would be amazing > for me. I have had great great difficulty trying to find > wrapper for VB6! > Thanks once again. > I will try it out, and if I run into problems i will email you. > > Thanks once again. > > Pablopico > >> To: sqlite-users@sqlite.org >> From: [EMAIL PROTECTED] >> Date: Wed, 30 Apr 2008 03:17:30 + >> Subject: Re: [sqlite] Hello I am a newbie : for SQLite : Create db : VB6 >> >> palmer ristevski <[EMAIL PROTECTED]> writes: >> >> Hi Palmer, >> >> > I am new to this type of Forum.Here is my question : >> > My development platform is VB6. I am using "SQLitePlus >> > COM-DLL" from ez-tools.com.They have code to access >> > and query an existing ".db" file, but I wish to know >> > how to make a function call to create new SQLite >> > database files on harddisk.How would you do this using >> > VB6?What is the function call that you would have to make. >> > I know how to do this with SQLite at the command >> > line, and I could use VB6 to execute these commands >> > at the command line, but I want a more direct way to create >> > new database files.Hope someone can help me out. >> >> Sorry, no experience with the SQLitePlus-COM-wrapper >> (maybe you should ask their technical support). >> >> In case you want to try out something, working >> similar to "ADO/DAO-style"... >> The following example is Code for my COM-wrapper, >> which is available here: >> www.datenhaus.de/Downloads/dhRichClientDemo.zip >> It consists of three Binaries, placed in the >> Public Domain: >> dhRichClient.dll (COM-Dll - ADO-like WrapperClasses) >> sqlite35_engine.dll (StdCall-Dll, based on SQLite 3.5.7) >> DirectCOM.dll (Std-Dll, allows regfree COM-instancing) >> >> Small example how to use it, including the >> creation of a new DB, in case the file doesn't >> exists yet: >> >> Dim Cnn As cConnection, Cmd As cCommand, Rs As cRecordset >> Dim i As Long, FileName As String >> FileName = "c:MyFile.db" >> >> Set Cnn = New cConnection 'create a Cnn-Object >> >> On Error Resume Next >> Cnn.OpenDB FileName 'attempt, to open a DB-file >> If Err Then 'DB-File doesn't exists... >> Cnn.CreateNewDB FileName '...so we create one >> End If >> >> 'Ok, let's create a table >> Cnn.Execute "Create Table If Not Exists " & _ >> "Tbl(ID Integer Primary Key, Txt Text)" >> >> 'now we insert a few records over a Command-Object >> Set Cmd = Cnn.CreateCommand("Insert Into Tbl Values(?,?)") >> For i = 1 To 5 >> Cmd.SetText 2, "SomeText_" & i >> Cmd.Execute >> Next i >> >> 'and finally we request a Resultset... >> Set Rs = Cnn.OpenRecordset("Select * From Tbl") >> >> Do Until Rs.EOF 'loop over it... >> Debug.Print Rs!ID, Rs!Txt '...and print its contents >> Rs.MoveNext >> Loop >> >> >> Olaf Schmidt >> >> >> >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _ > Express yourself wherever you are. Mobilize! > http://www.gowindowslive.com/Mobile/Landing/Messenger/Default.aspx?Locale=en-US?ocid=TAG_APRIL > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > This message was sent using IMP, the Internet Messaging Program. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Hello I am a newbie : for SQLite : Create db : VB6
That is Great OLAF That is all that I am looking for. I just want to be able to create new files, then create tables and populate them and do simple queries. If I can do that with your stuff, that would be amazing for me. I have had great great difficulty trying to find wrapper for VB6! Thanks once again. I will try it out, and if I run into problems i will email you. Thanks once again. Pablopico > To: sqlite-users@sqlite.org > From: [EMAIL PROTECTED] > Date: Wed, 30 Apr 2008 03:17:30 + > Subject: Re: [sqlite] Hello I am a newbie : for SQLite : Create db : VB6 > > palmer ristevski <[EMAIL PROTECTED]> writes: > > Hi Palmer, > > > I am new to this type of Forum.Here is my question : > > My development platform is VB6. I am using "SQLitePlus > > COM-DLL" from ez-tools.com.They have code to access > > and query an existing ".db" file, but I wish to know > > how to make a function call to create new SQLite > > database files on harddisk.How would you do this using > > VB6?What is the function call that you would have to make. > > I know how to do this with SQLite at the command > > line, and I could use VB6 to execute these commands > > at the command line, but I want a more direct way to create > > new database files.Hope someone can help me out. > > Sorry, no experience with the SQLitePlus-COM-wrapper > (maybe you should ask their technical support). > > In case you want to try out something, working > similar to "ADO/DAO-style"... > The following example is Code for my COM-wrapper, > which is available here: > www.datenhaus.de/Downloads/dhRichClientDemo.zip > It consists of three Binaries, placed in the > Public Domain: > dhRichClient.dll (COM-Dll - ADO-like WrapperClasses) > sqlite35_engine.dll (StdCall-Dll, based on SQLite 3.5.7) > DirectCOM.dll (Std-Dll, allows regfree COM-instancing) > > Small example how to use it, including the > creation of a new DB, in case the file doesn't > exists yet: > > Dim Cnn As cConnection, Cmd As cCommand, Rs As cRecordset > Dim i As Long, FileName As String > FileName = "c:\MyFile.db" > > Set Cnn = New cConnection 'create a Cnn-Object > > On Error Resume Next > Cnn.OpenDB FileName 'attempt, to open a DB-file > If Err Then 'DB-File doesn't exists... > Cnn.CreateNewDB FileName '...so we create one > End If > > 'Ok, let's create a table > Cnn.Execute "Create Table If Not Exists " & _ > "Tbl(ID Integer Primary Key, Txt Text)" > > 'now we insert a few records over a Command-Object > Set Cmd = Cnn.CreateCommand("Insert Into Tbl Values(?,?)") > For i = 1 To 5 > Cmd.SetText 2, "SomeText_" & i > Cmd.Execute > Next i > > 'and finally we request a Resultset... > Set Rs = Cnn.OpenRecordset("Select * From Tbl") > > Do Until Rs.EOF 'loop over it... > Debug.Print Rs!ID, Rs!Txt '...and print its contents > Rs.MoveNext > Loop > > > Olaf Schmidt > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _ Express yourself wherever you are. Mobilize! http://www.gowindowslive.com/Mobile/Landing/Messenger/Default.aspx?Locale=en-US?ocid=TAG_APRIL ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Hello I am a newbie : for SQLite : Create db : VB6
palmer ristevski <[EMAIL PROTECTED]> writes: Hi Palmer, > I am new to this type of Forum.Here is my question : > My development platform is VB6. I am using "SQLitePlus > COM-DLL" from ez-tools.com.They have code to access > and query an existing ".db" file, but I wish to know > how to make a function call to create new SQLite > database files on harddisk.How would you do this using > VB6?What is the function call that you would have to make. > I know how to do this with SQLite at the command > line, and I could use VB6 to execute these commands > at the command line, but I want a more direct way to create > new database files.Hope someone can help me out. Sorry, no experience with the SQLitePlus-COM-wrapper (maybe you should ask their technical support). In case you want to try out something, working similar to "ADO/DAO-style"... The following example is Code for my COM-wrapper, which is available here: www.datenhaus.de/Downloads/dhRichClientDemo.zip It consists of three Binaries, placed in the Public Domain: dhRichClient.dll (COM-Dll - ADO-like WrapperClasses) sqlite35_engine.dll (StdCall-Dll, based on SQLite 3.5.7) DirectCOM.dll (Std-Dll, allows regfree COM-instancing) Small example how to use it, including the creation of a new DB, in case the file doesn't exists yet: Dim Cnn As cConnection, Cmd As cCommand, Rs As cRecordset Dim i As Long, FileName As String FileName = "c:\MyFile.db" Set Cnn = New cConnection 'create a Cnn-Object On Error Resume Next Cnn.OpenDB FileName 'attempt, to open a DB-file If Err Then 'DB-File doesn't exists... Cnn.CreateNewDB FileName '...so we create one End If 'Ok, let's create a table Cnn.Execute "Create Table If Not Exists " & _ "Tbl(ID Integer Primary Key, Txt Text)" 'now we insert a few records over a Command-Object Set Cmd = Cnn.CreateCommand("Insert Into Tbl Values(?,?)") For i = 1 To 5 Cmd.SetText 2, "SomeText_" & i Cmd.Execute Next i 'and finally we request a Resultset... Set Rs = Cnn.OpenRecordset("Select * From Tbl") Do Until Rs.EOF 'loop over it... Debug.Print Rs!ID, Rs!Txt '...and print its contents Rs.MoveNext Loop Olaf Schmidt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Hello I am a newbie : for SQLite : Create db : VB6
I am new to this type of Forum.Here is my question : My development platform is VB6. I am using "SQLitePlus COM-DLL" from ez-tools.com.They have code to access and query an existing ".db" file, but I wish to know how to make a function call to create new SQLite database files on harddisk.How would you do this using VB6?What is the function call that you would have to make.I know how to do this with SQLite at the command line, and I could use VB6 to execute these commands at the command line, but I want a more direct way to create new database files.Hope someone can help me out. Pablopico> Date: Tue, 29 Apr 2008 20:32:32 +0200> From: [EMAIL PROTECTED]> To: [EMAIL PROTECTED]> Subject: Re: Hello I am a newbie> > Hello Pablopico,> > i am sorry, but i can not answer your question. I do not know VB. How > did you find my eMail - address anyway?> > To join the sqlite mailing list, visit> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > and follow the instructions. Then post your questions by mailing them to> > sqlite-users@sqlite.org> > Good luck,> Martin> > [EMAIL PROTECTED] wrote:> > I am new to this type of Forum.> > I don't know how one is supposed to post to this forum.> > I don't see a "POST" button on this site.> > Based on email information I got from SQLite users, is this> > all done via 'email posting'?> >> > Anyways, I also have a question.> > My development platform is VB6. I am using "SQLitePlus COM-DLL" from > > ez-tools.com.> > They have code to access and query an existing ".db" file, but I wish to know how to make a function call to create new SQLite database files on harddisk.> > How would you do this using VB6?> > What is the function call that you would have to make.> > I know how to do this with SQLite at the command line, and I could use VB6 to execute these commands at the command line, but I want a more direct way to create new database files.> >> > Hope you can help me out.> >> > Pablopico> >> >> > > _ Back to work after baby–how do you know when you’re ready? http://lifestyle.msn.com/familyandparenting/articleNW.aspx?cp-documentid=5797498&ocid=T067MSN40A0701A ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users