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=5797498ocid=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
[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=5797498ocid=T067MSN40A0701A ___ 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
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
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
