[sqlite] REQ: How do I change one character in a field value for another
Hi All, I need to change all occurances of a character in a field to another character, as I dont use sqlite very often, I can select the records but cannot work out how to code the change character part. Can anyone help? I need to cange all occurences of ~ (tilde) to - (dash) the select statement is thus: select OperatorFlagCode from Aircraft where OperatorFlagCode like '%~%' thanks in anticipation -- ¿¿¿ (ô ô) [EMAIL PROTECTED] ooO-(_)-Ooo http://www.westrowops.co.uk Wot! No SBS? IAT Boscombe Down Aircrew Transport 1989 RIAT Fairford Checklist Team 1990-2008 RAF Waddington Checklist Team 1995-2007 RNAS Yeovilton Checklist Team 2005,2007 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] REQ: How do I change one character in a field value for another
Hi, look at the replace() - Function at http://www.sqlite.org/lang_expr.html#corefunctions and use a statement like update Aircraft set OperatorFlagCode = replace(OperatorFlagCode, '~','-') where ... OperatorFlagCode like '%~%' Martin Hi All, I need to change all occurances of a character in a field to another character, as I dont use sqlite very often, I can select the records but cannot work out how to code the change character part. Can anyone help? I need to cange all occurences of ~ (tilde) to - (dash) the select statement is thus: select OperatorFlagCode from Aircraft where OperatorFlagCode like '%~%' thanks in anticipation ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] temp tables and PRAGMA temp_store
Using the latest SQLite and trying to speed up the making of some intermediate tables. I thought I could do that by doing PRAGMA temp_store = MEMORY and CREATE TEMP TABLE etc. I do run the PRAGMA directly after establishing the SQLite connection. So far I haven't seen any speed increase yet and I am wondering if maybe I am doing something wrong here. Does this PRAGMA only work on a newly created db file? Have tried that, but again no difference. Would you expect a speed increase from doing the above? I am running this from VB with the wrapper from Olaf Schmidt. Thanks for any advice. RBS ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] In memory data base questions ???
Hi, I am planning to use only in-memory data base for my application. I have couple of questions? 1) Would SQLite still make Rollback Journal files? If yes can it be turned off with pragma, etc.? 2) If I have a single in-memory connection with multiple statements, should I worry about table locks? Thanks, -Alex ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQLite full text speed
I'm curious about the speed trade off between a full table scan and just a flat file search... Say I have a database with 2 records in it. If I do a query like: SELECT foo FROM table WHERE bar LIKE '%glaven%'; That will be a full text scan across the table. Would that be any faster than just a regexp against a flat text file? Obviously you get the advantages of SQL were it in a DB, versus a flat file. What other trade offs are there? My experience the above, is that in SQLITE it's still incredibly fast. -- Scott Baker - Canby Telcom RHCE - System Administrator - 503.266.8253 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] What is faster?
I am more interesting in theoretical answer :) On Fri, Apr 25, 2008 at 5:24 PM, Federico Granata [EMAIL PROTECTED] wrote: If you are under linux you can use time command to execute sqlite with various query and see which one is faster. -- [image: Just A Little Bit Of Geekness]http://feeds.feedburner.com/%7Er/JustALittleBitOfGeekness/%7E6/1 Le tre grandi virtù di un programmatore: pigrizia, impazienza e arroganza. (Larry Wall). On Fri, Apr 25, 2008 at 10:04 AM, Alexander Batyrshin [EMAIL PROTECTED] wrote: Hello people, I have two SQL commands doing the same thing: 1. SELECT id FROM foo WHERE expr1 EXCEPT SELECT id FROM bar WHERE expr2 2. SELECT id FROM foo WHERE expr1 AND id not IN (SELECT id FTOM bar WHERE expr2) Can you say which one is faster? I prefer second option because I can use extra condition like LIMIT. -- Alexander Batyrshin aka bash bash = Biomechanica Artificial Sabotage Humanoid ___ 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 -- Alexander Batyrshin aka bash bash = Biomechanica Artificial Sabotage Humanoid ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite full text speed
On 4/29/08, Scott Baker [EMAIL PROTECTED] wrote: I'm curious about the speed trade off between a full table scan and just a flat file search... Say I have a database with 2 records in it. If I do a query like: SELECT foo FROM table WHERE bar LIKE '%glaven%'; That will be a full text scan across the table. Would that be any faster than just a regexp against a flat text file? Obviously you get the advantages of SQL were it in a DB, versus a flat file. What other trade offs are there? My experience the above, is that in SQLITE it's still incredibly fast. Every now and then we get questions about will such and such be fast or that and that be faster. The only definitive way to find out is to benchmark, and the poser of the question is in a much better position to answer than anyone else. 20,000 records means nothing at all... is it 20,000 records aka rows of what? How big is the value of bar? Of course, in SQLite there is no column width concept, so one could stuff in a 10,000 words novel in a column of a row and drastically change the result. That said, my sense is that probably grep against a 20K word file would be faster than SQLite, but again, I am pulling that sense out of thin air. I am too lazy to find a 20K file, grep against it for a pattern, then make a table out of it, and SQL search against it using SQLite. The definitive answer is only to be found, however, by benchmarking. -- Scott Baker - Canby Telcom RHCE - System Administrator - 503.266.8253 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ ___ 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] In memory data base questions ???
Alex Katebi [EMAIL PROTECTED] wrote: I am planning to use only in-memory data base for my application. I have couple of questions? 1) Would SQLite still make Rollback Journal files? No. 2) If I have a single in-memory connection with multiple statements, should I worry about table locks? No. Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] In memory data base questions ???
Hi Igor, So are you telling me that if a statement has started a select on a table with a delayed finalize another statement can update the same table? The reason I ask this question is that in my application a user can start a query and take his time before he ends it. Meanwhile the same table needs to be updated by my application. Can you tell be why there would be no lock contention? Thanks! -Alex On Tue, Apr 29, 2008 at 5:39 PM, Igor Tandetnik [EMAIL PROTECTED] wrote: Alex Katebi [EMAIL PROTECTED] wrote: I am planning to use only in-memory data base for my application. I have couple of questions? 1) Would SQLite still make Rollback Journal files? No. 2) If I have a single in-memory connection with multiple statements, should I worry about table locks? No. Igor Tandetnik ___ 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] In memory data base questions ???
Just want to make a note that when I say in-memory data base I don't mean the cache memory I mean the :memory: date base. On Tue, Apr 29, 2008 at 5:39 PM, Igor Tandetnik [EMAIL PROTECTED] wrote: Alex Katebi [EMAIL PROTECTED] wrote: I am planning to use only in-memory data base for my application. I have couple of questions? 1) Would SQLite still make Rollback Journal files? No. 2) If I have a single in-memory connection with multiple statements, should I worry about table locks? No. Igor Tandetnik ___ 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] In memory data base questions ???
Alex Katebi [EMAIL PROTECTED] wrote: So are you telling me that if a statement has started a select on a table with a delayed finalize another statement can update the same table? Yes, as of recent enough SQLite version. I'm kind of skeptical myself, but Dr. Hipp insists this is possible and safe. I haven't personally worked up the courage to use this feature though. I do update one table while scrolling through another - that works. The reason I ask this question is that in my application a user can start a query and take his time before he ends it. Meanwhile the same table needs to be updated by my application. Can you tell be why there would be no lock contention? There is a lock (not the file-level database lock, but the OS mutex) during the call to sqlite3_step. But other than that, there's no contention. In other words, your update statement may have to wait while the select retrieves the next row, but it won't have to wait until you retrieve the complete recordset. Of course, there is no transaction isolation between the two statements, you are in dirty read mode. E.g., sufficiently complex SQL statemets may need to read the same row of the same table more than once: it is possible that one such read would see the original data and the other modified data. The recordset thus produced might be, shall we say, interesting. Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] In memory data base questions ???
Alex Katebi [EMAIL PROTECTED] wrote: Just want to make a note that when I say in-memory data base I don't mean the cache memory I mean the :memory: date base. That's how I understood you, yes. Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] What is faster?
When it is so easy to test, who cares about theoretical answers? It's been 5 days since you asked and would have taken 5 minutes to test! Try It And See(tm). On Tue, Apr 29, 2008 at 11:53 AM, Alexander Batyrshin [EMAIL PROTECTED] wrote: I am more interesting in theoretical answer :) On Fri, Apr 25, 2008 at 5:24 PM, Federico Granata [EMAIL PROTECTED] wrote: If you are under linux you can use time command to execute sqlite with various query and see which one is faster. -- [image: Just A Little Bit Of Geekness]http://feeds.feedburner.com/%7Er/JustALittleBitOfGeekness/%7E6/1 Le tre grandi virtù di un programmatore: pigrizia, impazienza e arroganza. (Larry Wall). On Fri, Apr 25, 2008 at 10:04 AM, Alexander Batyrshin [EMAIL PROTECTED] wrote: Hello people, I have two SQL commands doing the same thing: 1. SELECT id FROM foo WHERE expr1 EXCEPT SELECT id FROM bar WHERE expr2 2. SELECT id FROM foo WHERE expr1 AND id not IN (SELECT id FTOM bar WHERE expr2) Can you say which one is faster? I prefer second option because I can use extra condition like LIMIT. -- Alexander Batyrshin aka bash bash = Biomechanica Artificial Sabotage Humanoid ___ 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 -- Alexander Batyrshin aka bash bash = Biomechanica Artificial Sabotage Humanoid ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Cory Nelson http://www.int64.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] a suggestion to write tutorial for sqlite
http://www.amazon.com/Definitive-Guide-SQLite/dp/1590596730 Excellent book! On Sat, Apr 19, 2008 at 12:37 PM, mikeobe [EMAIL PROTECTED] wrote: i found it boring to learn how to use sqlite, maybe we can write a tutorial for it, with examples, it will be much easier for the beginner to start with sqlite. 2008-04-19 mikeobe ___ 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] Bindings problem
Hi I'm new to Sqlite and Python and have hit a snag. I have a function that receives a single parameter record that contains the contents for the column testdata The program fails with the message: Incorrect number of bindings supplied. The current statement uses 0, and there are 10 supplied There are 10 chars in the string variable that gets passed...it looks like the code sees each char in the string as a separate binding? The source is as follows: def updateDb(record): c.execute('INSERT INTO ardrecords (testdata) VALUES (?)', (record)) Thanks for the help. Alan ___ 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] temp tables and PRAGMA temp_store
RB Smissaert [EMAIL PROTECTED] writes: Using the latest SQLite and trying to speed up the making of some intermediate tables. I thought I could do that by doing PRAGMA temp_store = MEMORY and CREATE TEMP TABLE etc. I do run the PRAGMA directly after establishing the SQLite connection. So far I haven't seen any speed increase yet and I am wondering if maybe I am doing something wrong here. Does this PRAGMA only work on a newly created db file? Have tried that, but again no difference. Would you expect a speed increase from doing the above? I am running this from VB with the wrapper from Olaf Schmidt. Hi Bart, the reason why you don't see any changes is, that this is already the default in my version of the SQLite-engine compile (sqlite35_engine.dll). ;-) Olaf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Bindings problem
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Alan Hyde wrote: def updateDb(record): c.execute('INSERT INTO ardrecords (testdata) VALUES (?)', (record)) Short answer: You should not be quoting the ? and are missing a comma after record. Long answer: Quoting the question mark inserts a question mark and is not a binding. Also SQL uses single quotes as standard for strings with double quotes resulting in implementation specific behaviour. (record) is the same as record - to make it a sequence of the string you need to use (record,). The final result should be: def updateDb(record): c.execute('INSERT INTO ardrecords (testdata) VALUES (?)', (record,)) Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFIF+mTmOOfHg372QQRAvyAAJoCflNdTK8SqaitpgDEVxxQrlKVFQCfdcyu QTpI30wDGQKgyjHBhiTkiuA= =ETTQ -END PGP SIGNATURE- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Recommended pragmas for new SQLite users to focus on
I'm new to SQLite and have been reading the archives for background. Are there a common set of pragmas that a new developer should master and if so which ones do you recommend I focus on? Is there a 'best practice' standard set of pragmas that apply to most applications? (I'm thinking PRAGMA TEMP_STORE = MEMORY and possibly others???) BTW: I'm interfacing to SQLite via Python 2.5 on Windows and Linux systems with lots of RAM. Thank you, Malcolm ___ 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
[sqlite] Bindings problem
Thank you Roger - appreciated. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Recommended (Windows/Linux) SQLite utilities
Looking for recommendations for 3rd party SQLite utilities for browsing, maintaining, importing/exporting and repairing SQLite database files. My primary development environments are Windows and Linux although I'm open to Mac only products as well. My 'google' research on this topic follows my signature. Thank you, Malcolm SQLite utilites found via google: sqlite (utilities|utility) The following products are listed in reverse order of price. SQLite Analyzer, $100 http://www.kraslabs.com/sqlite_analyzer.php http://software.techrepublic.com.com/abstract.aspx?docid=222935q=analyzer Need a tool that would manage SQLite databases quickly and easily? SQLite Analyzer is the best Internet has to offer. This tool is a comprehensive SQLite database processor that allows editing or modifying SQLite tables visually without any risk of losing data. There are no table size restrictions! Add tree-like database structure display, syntax highlighting, instant script generation. SQLite Analyzer is the best Internet has to offer. This tool is a comprehensive SQLite database processor that allows editing or modifying SQLite tables visually without any risk of losing data. There are no table size restrictions. Add tree-like database structure display, syntax highlighting, instant script generation to understand why professionals choose SQLite Analyzer. ### SQLite Maestro, $100 http://www.sqlmaestro.com/products/sqlite/maestro/ SQLite Maestro is the premier SQLite admin tool designed to meet the requirements of SQLite users and to make the work with the databases simpler and more comfortable. SQLite Maestro allows you to create, edit, copy, extract and drop all the database objects such as tables, views, build queries visually, execute queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/from most popular file formats, and use a lot of other admin tools designed for the easiest and most efficient work with SQLite databases. SQLite Maestro allows you to build diagrams based on SQLite data. This exclusive feature represents numeric data from a table or a query result as a diagram with a possibility of customizing its appearance in various ways. You can also easy export the diagram to the following formats: BMP, Windows metafile, PDF, JPEG, PNG and more. ### SQLite Data Wizard, $100 http://jcay.com/tools-and-utilities/database-tools/sqlite-data-wizard.html SQLite Data Wizard is a powerful Windows GUI utility for managing your data. It provides you with a number of easy-to-use tools for performing the required data manipulation easily and quickly. * ASP.NET Generator: create a full set of ASP.NET scripts in a few mouse clicks * PHP Generator: get high-quality web applications without manual coding * Data Pump: transfer any ADO-compatible database to SQLite * Data export to as many as 14 file formats including Excel, RTF and HTML * Data import from Excel, CSV, text files and more * Flexible Task Scheduler * The Agent application to execute tasks in background mode ### SQLite Code Factory, $80 http://www.sqlmaestro.com/products/sqlite/codefactory/ SQLite Code Factory is a premier SQLite GUI tool aimed at the SQL queries and scripts development. Key features include: * Visual Query Builder * Handy SQL Editor with code folding and syntax highlighting * Simultaneous executing of several queries with multi-threading * Data management: viewing, editing, grouping, sorting and filtering abilities * Data export to as many as 14 file formats including Excel, RTF and HTML * Data import from Excel, CSV, text files and more * Powerful BLOB Viewer/Editor The application also provides you with a powerful set of tools to edit and execute SQL scripts, build visual diagrams for numeric data, customize user interface according to your needs and much more. ### SQLite3 Database Manager, $60 http://www.filedepot.eu/sqliteman/ Win32 application to manage SQLite3 database. Development tool for managing all database objects: * Tables * Views * Indexes * Triggers * SQL builder * Export schema and data to InterBASE, Firebird and other databases. ### SQLiteManager, $50 http://www.sqlabs.net/sqlitemanager.php SQLiteManager is a next generation GUI database manager for sqlite databases, it combines an incredible easy to use interface with blazing speed and advanced features. SQLiteManager allows you to open and work with sqlite 2.x, sqlite 3.x, in memory databases and REALSQL Server databases. It allows you to create and browse tables, views, triggers and indexes. It enables you to insert, delete and updates records in a very intuitive way and it supports you arbitrary SQL commands. SQLiteManager's report generation system is flexible enough to let you generate reports in just about any format you can imagine (report generation can actually be used to export data in just about any format you need). You create the report templates using a report template language and
Re: [sqlite] Recommended (Windows/Linux) SQLite utilities
On 4/29/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Looking for recommendations for 3rd party SQLite utilities for browsing, maintaining, importing/exporting and repairing SQLite database files. My primary development environments are Windows and Linux although I'm open to Mac only products as well. My 'google' research on this topic follows my signature. http://www.sqlite.org/cvstrac/wiki?p=ManagementTools Thank you, Malcolm SQLite utilites found via google: sqlite (utilities|utility) The following products are listed in reverse order of price. SQLite Analyzer, $100 http://www.kraslabs.com/sqlite_analyzer.php http://software.techrepublic.com.com/abstract.aspx?docid=222935q=analyzer Need a tool that would manage SQLite databases quickly and easily? SQLite Analyzer is the best Internet has to offer. This tool is a comprehensive SQLite database processor that allows editing or modifying SQLite tables visually without any risk of losing data. There are no table size restrictions! Add tree-like database structure display, syntax highlighting, instant script generation. SQLite Analyzer is the best Internet has to offer. This tool is a comprehensive SQLite database processor that allows editing or modifying SQLite tables visually without any risk of losing data. There are no table size restrictions. Add tree-like database structure display, syntax highlighting, instant script generation to understand why professionals choose SQLite Analyzer. ### SQLite Maestro, $100 http://www.sqlmaestro.com/products/sqlite/maestro/ SQLite Maestro is the premier SQLite admin tool designed to meet the requirements of SQLite users and to make the work with the databases simpler and more comfortable. SQLite Maestro allows you to create, edit, copy, extract and drop all the database objects such as tables, views, build queries visually, execute queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/from most popular file formats, and use a lot of other admin tools designed for the easiest and most efficient work with SQLite databases. SQLite Maestro allows you to build diagrams based on SQLite data. This exclusive feature represents numeric data from a table or a query result as a diagram with a possibility of customizing its appearance in various ways. You can also easy export the diagram to the following formats: BMP, Windows metafile, PDF, JPEG, PNG and more. ### SQLite Data Wizard, $100 http://jcay.com/tools-and-utilities/database-tools/sqlite-data-wizard.html SQLite Data Wizard is a powerful Windows GUI utility for managing your data. It provides you with a number of easy-to-use tools for performing the required data manipulation easily and quickly. * ASP.NET Generator: create a full set of ASP.NET scripts in a few mouse clicks * PHP Generator: get high-quality web applications without manual coding * Data Pump: transfer any ADO-compatible database to SQLite * Data export to as many as 14 file formats including Excel, RTF and HTML * Data import from Excel, CSV, text files and more * Flexible Task Scheduler * The Agent application to execute tasks in background mode ### SQLite Code Factory, $80 http://www.sqlmaestro.com/products/sqlite/codefactory/ SQLite Code Factory is a premier SQLite GUI tool aimed at the SQL queries and scripts development. Key features include: * Visual Query Builder * Handy SQL Editor with code folding and syntax highlighting * Simultaneous executing of several queries with multi-threading * Data management: viewing, editing, grouping, sorting and filtering abilities * Data export to as many as 14 file formats including Excel, RTF and HTML * Data import from Excel, CSV, text files and more * Powerful BLOB Viewer/Editor The application also provides you with a powerful set of tools to edit and execute SQL scripts, build visual diagrams for numeric data, customize user interface according to your needs and much more. ### SQLite3 Database Manager, $60 http://www.filedepot.eu/sqliteman/ Win32 application to manage SQLite3 database. Development tool for managing all database objects: * Tables * Views * Indexes * Triggers * SQL builder * Export schema and data to InterBASE, Firebird and other databases. ### SQLiteManager, $50 http://www.sqlabs.net/sqlitemanager.php SQLiteManager is a next generation GUI database manager for sqlite databases, it combines an incredible easy to use interface with blazing speed and advanced features. SQLiteManager allows you to open and work with sqlite 2.x, sqlite 3.x, in memory databases and REALSQL Server databases. It allows you to create and browse tables, views, triggers and indexes. It enables you to insert, delete and updates records in a very intuitive way and it supports you arbitrary SQL
Re: [sqlite] Recommended (Windows/Linux) SQLite utilities
P Kishor, http://www.sqlite.org/cvstrac/wiki?p=ManagementTools Oops, that's embarrassing! Do you have a favorite on this page that you would recommend? Thank you, Malcolm ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users