Re: [sqlite] importing data to sqlite from stdin
Hi there,
This Talend you mentioned caught my eye. Can one use this tool as a general
database browser tool.
Palmer
> Date: Mon, 29 Jun 2009 08:56:58 -0700
> From: g...@talend.com
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] importing data to sqlite from stdin
>
>
> What you could use is an open source ETL that has connectors with Sqlite.
>
> Talend Open Studio is an open source ETL tool for data integration and
> migration experts. It's easy to learn for a non-technical user. What
> distinguishes Talend, when it comes to business users, is the tMap
> component. It allows the user to get a graphical and functional view of
> integration processes.
>
> For more information: http://www.talend.com/
>
>
>
> Robert Citek-2 wrote:
> >
> > On occasion I have had a need to import large amounts of data from
> > standard input via a pipe. Here's an example of how to import from a
> > pipe using sqlite3 on Ubuntu:
> >
> > $ { grep -v '^#' < > # create the table
> > create table foo (bar int) ;
> > eof
> > } | sqlite3 foo.sqlite
> >
> > $ seq 1 100 | sqlite3 foo.sqlite '.imp "/dev/stdin" "foo"'
> >
> > $ sqlite3 foo.sqlite 'select count(*) from foo; '
> > 100
> >
> > Regards,
> > - Robert
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/importing-data-to-sqlite-from-stdin-tp24256696p24256851.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_
Hotmail® has ever-growing storage! Don’t worry about storage limits.
http://windowslive.com/Tutorial/Hotmail/Storage?ocid=TXT_TAGLM_WL_HM_Tutorial_Storage_062009
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Question about Referential IntegrityRE: Foreign key support
Just wondering when/if Richard will make SQLite having referential Integrity a priority. Is it on the TODO list? Is it #1 or #100 on this TODO list. Because almost all other common databases have this. Once it has this feature I think that it will become even more popular. Signing off Great Fan of SQLite P. > From: danielk1...@gmail.com> To: sqlite-users@sqlite.org> Date: Sat, 31 Jan > 2009 00:28:05 +0700> Subject: Re: [sqlite] Foreign key support> > > On Jan > 31, 2009, at 12:25 AM, Adam DeVita wrote:> > > Good day,> >> > If I write > into the sqlite3 using the analyzer:> >> > create table mysns (SN int primary > key, desc text);> > insert into mysns (SN, desc) values (1,2);> > create > table t2 (mynum int, desc2 text, SN references mysns(SN) );> >> > insert into > t2 (mynum, desc2, SN) values (1,"two", 3);> >> > This insert didn't produce > an error, despite the fact 3 isn't in table> > mysns. Why?> > Foreign keys > are not supported. See the first entry in> this list:> > > http://www.sqlite.org/omitted.html> > > >> >> > regards,> > Adam> > > ___> > 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 _ Windows Live™: Keep your life in sync. http://windowslive.com/explore?ocid=TXT_TAGLM_WL_t1_allup_explore_022009 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] best language match for SQLite?
Glory Be to You! That is the platform I am currently moving into! Adobe Flex/Air where Desktop App and Web Apps merge! P. > To: sqlite-users@sqlite.org > Date: Tue, 16 Sep 2008 17:33:09 -0400 > From: [EMAIL PROTECTED] > Subject: Re: [sqlite] best language match for SQLite? > > Um... excuse me! You can all move to the side and make room for Flex > and AIR! > > Ciao! > Javi > > On Sep 16, 2008, at 5:29 PM, A. H. Ongun wrote: > > > Best language to use is the one that is suited for the job. > > > > Examples: > > I use Perl as a gluing language to connect various subsystems > > together, and as a swiss army knife. > > C, C++ for embedded development on Linux. > > C++ for Windows development. > > Forth for embedded development on some specialized hardware. > > SQL for Oracle, and MS SQL work. > > > > and Vim to rule them all. :) > > > > andy > > > > > > "Message: 1 > > Date: Tue, 16 Sep 2008 11:50:40 -0400 > > From: Patrick <[EMAIL PROTECTED]> > > Subject: [sqlite] best language match for SQLite? > > To: General Discussion of SQLite Database > > Message-ID: <[EMAIL PROTECTED]> > > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > > > I am a beginner to intermediate Python Programmer. I can use SQLite > > with > > it just fine but it is my understanding that relational database and > > object oriented programming our not the perfect marriage. > > > > I was just wondering if anyone had an opinion on the most ideal > > language > > to use with SQLite? > > > > I love Python but I LOVE SQLite, I would learn another language just > > to > > use it better-Patrick " > > > > > > > > > > ___ > > 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 _ Want to do more with Windows Live? Learn “10 hidden secrets” from Jamie. http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns!550F681DAD532637!5295.entry?ocid=TXT_TAGLM_WL_domore_092008 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] best language match for SQLite?
I don't see any problems with people waving the FLAGS of their favorite programming languages. The more FLAG waving the merrier i say, and people will get to see the many languages being used by the users of SQLite! This is a wonderful venue for freedom of expression and exchange of points of view on the different programming languages and SQLite! P. > Date: Tue, 16 Sep 2008 15:27:57 -0500 > From: [EMAIL PROTECTED] > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] best language match for SQLite? > > My advice was not to have the tail wag the dog. Choose you language as > appropriate for the application. Sqlite fits everywhere. For example > if it is an embedded system use C. If it it something else a script > system like Perl of whatever would be appropriate. > > If you want an ideally integrated platform use TCL. > > Martin (OPENGeoMap) wrote: > > Mohit Sindhwani escribió: > >> Jeff Godfrey wrote: > >> > >>> According to a paper written by Richard Hipp (the creator of SQLite), > >>> Tcl is the ideal language. Here's a quote from the mentioned paper: > >>> > >>> "The increasing popularity of SQLite is seen in the fact that the main > >>> website daily serves about a gigabyte of data to around 3000 unique IP > >>> addresses. SQLite has been eagerly embraced by PHP, Perl, and Python > >>> programmers. What most of these enthusiastic users fail to realize is > >>> that SQLite bindings for the three P-languages are an afterthought. > >>> SQLite was designed from the beginning to be used with Tcl. Tcl bindings > >>> have been in the SQLite core since before version 1.0 and almost half of > >>> the SQLite source code base consists of regression test scripts written > >>> in Tcl. SQLite wants to be programmed in Tcl, not those other languages." > >>> > >>> The entire paper can be found here: > >>> > >>> http://www.tcl.tk/community/tcl2004/Papers/D.RichardHipp/drh.html > >>> > >> While that's true, Ruby works really well with SQLite! > >> > > Ruby rocks. C# rocks. D rocks. I used ruby in a project and i am very > > happy. /gem install sqlite3/-ruby ... > > This 3 languages are completed from the begining and with different uses. > > > > For me the universe must be in C and autocreate bindings to other > > languages is direct if the C APi is well designed. > > http://live.gnome.org/Vala > > http://live.gnome.org/GObjectIntrospection > > If you design a masterful API in C, you can access to all languages like > > JAVA, c#, ruby, python, PERL,D, C++, ... > > This is the perfect sample of this API: > > http://library.gnome.org/devel/glib/2.18/ > > This is the perfect sample of a full Object oriented API in C with Gobject: > > http://library.gnome.org/devel/gtk/stable/ > > > > I doubt SQLite was more apropiate to use in TCL. I see the C API of > > SQlite very clean and easy to hack in other languages. > > > > In my opinion TCL.like perl, is death and sucks in my opinion. > > Ofusctated life... > > > > PD: I was PERL user in the past and i change it for ruby. > > > > Regards > >> Cheers, > >> Mohit. > >> 9/17/2008 | 12:11 AM. > >> > >> ___ > >> 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-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _ Stay up to date on your PC, the Web, and your mobile phone with Windows Live. http://clk.atdmt.com/MRT/go/msnnkwxp1020093185mrt/direct/01/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] best language match for SQLite?
"Of course; but VB (VB6) is just a bit better." YES brothers, Educate them, Educate them For you see those 2 are actually my two main programming platforms! Disciples go forth to educate the peoples! P. > Date: Tue, 16 Sep 2008 17:20:55 +0100 > From: [EMAIL PROTECTED] > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] best language match for SQLite? > > > "And of course, Perl is always best. :)" > > Of course; but VB (VB6) is just a bit better. > > RBS > > > > > > "And of course, Perl is always best. :)" > > > > That's right brother! > > Educate them , Educate them i say! > > > > P. > > > >> Date: Tue, 16 Sep 2008 11:13:27 -0500 > >> From: [EMAIL PROTECTED] > >> To: sqlite-users@sqlite.org > >> Subject: Re: [sqlite] best language match for SQLite? > >> > >> SQLite is written in C, and its creators seem to be fond of TCL, so > >> those are 2 good choices, but I don't think there is a most ideal > >> language for anything - it all depends on balancing what you need to do > >> and what you want to learn. > >> > >> And of course, Perl is always best. :) > >> > >> g > >> > >> -Original Message- > >> From: Patrick [mailto:[EMAIL PROTECTED] > >> Sent: Tuesday, September 16, 2008 10:51 AM > >> To: General Discussion of SQLite Database > >> Subject: [sqlite] best language match for SQLite? > >> > >> I am a beginner to intermediate Python Programmer. I can use SQLite with > >> > >> it just fine but it is my understanding that relational database and > >> object oriented programming our not the perfect marriage. > >> > >> I was just wondering if anyone had an opinion on the most ideal language > >> > >> to use with SQLite? > >> > >> I love Python but I LOVE SQLite, I would learn another language just to > >> use it better-Patrick > >> > >> ___ > >> sqlite-users mailing list > >> sqlite-users@sqlite.org > >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > _ > > See how Windows connects the people, information, and fun that are part of > > your life. > > http://clk.atdmt.com/MRT/go/msnnkwxp1020093175mrt/direct/01/ > > ___ > > 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 _ Stay up to date on your PC, the Web, and your mobile phone with Windows Live. http://clk.atdmt.com/MRT/go/msnnkwxp1020093185mrt/direct/01/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] best language match for SQLite?
"And of course, Perl is always best. :)" That's right brother! Educate them , Educate them i say! P. > Date: Tue, 16 Sep 2008 11:13:27 -0500 > From: [EMAIL PROTECTED] > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] best language match for SQLite? > > SQLite is written in C, and its creators seem to be fond of TCL, so > those are 2 good choices, but I don't think there is a most ideal > language for anything - it all depends on balancing what you need to do > and what you want to learn. > > And of course, Perl is always best. :) > > g > > -Original Message- > From: Patrick [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 16, 2008 10:51 AM > To: General Discussion of SQLite Database > Subject: [sqlite] best language match for SQLite? > > I am a beginner to intermediate Python Programmer. I can use SQLite with > > it just fine but it is my understanding that relational database and > object oriented programming our not the perfect marriage. > > I was just wondering if anyone had an opinion on the most ideal language > > to use with SQLite? > > I love Python but I LOVE SQLite, I would learn another language just to > use it better-Patrick > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _ See how Windows connects the people, information, and fun that are part of your life. http://clk.atdmt.com/MRT/go/msnnkwxp1020093175mrt/direct/01/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Proposed removal of (mis-)feature
He is my vote. I like the fact that conventions #1 and #2 make things compatible with other databases. Does #3, by chance, do the same with another database not mentioned (eg. Oracle). If it does not have any compatibility with any other database, ONLY then I say that one should drop #3 quoting convention. Palmer > From: [EMAIL PROTECTED] > To: sqlite-users@sqlite.org > Date: Thu, 7 Aug 2008 13:26:07 -0400 > Subject: [sqlite] Proposed removal of (mis-)feature > > String literals in SQL are suppose to be enclosed in single-quotes - > Pascal-style. Double-quotes are used around table and/or column names > in cases where the name would otherwise be a keyword or when the name > contains non-standard characters. > > But SQLite tries to be flexible and accommodating. To this end, it > accepts some non-standard quoting mechanisms: > > 1. Names can be enclosed in [...] for compatibility with Access > and SQLServer. > 2. Names can be enclosed in grave accents for compatibility with > MySQL. > 3. Double-quoted names fall back to being string literals if > there is no matching table or column name. > > In retrospect, (3) seems to be a bad idea. It is accident-prone and > leads to all kinds of confusion. For example, if double-quotes are > being used correctly (which is to say to quote table or column names) > but a misspelling occurs in the name, the token reverts to being a > string literal rather than throwing an error. Or if a double-quoted > string really is being used as a string literal, but later a new > column is added to a table that has the same name as the string text, > the string literal will suddenly take on the value of the column. It > seems like we have one or two problem reports per month on this > mailing list that involve people using double-quoted names where they > should be using single-quoted string literals instead. > > So I'm giving some thought to removing feature (3) above and > disallowing double-quoted string literals. My concern is, though, > that this might break many existing applications. > > What opinion do you, gentle users, have of this matter? > > D. Richard Hipp > [EMAIL PROTECTED] > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _ Get more from your digital life. Find out how. http://www.windowslive.com/default.html?ocid=TXT_TAGLM_WL_Home2_082008 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] text datatype and referential integrity
Thanks Barefeet! I thought that it could be done with triggers, but I am knew and had difficult time finding good tutorials on triggers in SQLite. Thanks for your detailed code below. I always saw SQLite as trying to be the database to beat out MS Access for the desktop user. And due to this belief I thought that referential integrity would have been the one of the first fundamental things that would have been created from version 1.0, as wells as support for the basic fundamental types of joins. I hope these things will be coming in the next release. If this is done, in my opinion SQLite will have won over MS Access!!! I am waiting for that GLORIOUS day to come!!! Palmer > From: [EMAIL PROTECTED] > To: sqlite-users@sqlite.org > Date: Tue, 20 May 2008 09:22:59 +1000 > Subject: Re: [sqlite] text datatype and referential integrity > > Hi Palmer, > > >> Say one defines a column to be of text type, but you want only > >> 'text' to contain only alphabetic characters, no numeric > >> characters, how would one create this rule and enforce it in SQLite > >> SQL or does one have to use triggers. > > > > Perhaps something like this: > > > > create table t(x check (ltrim(x, 'ABC...Zabc...z') = '')); > > > > (with full alphabet in place of ellipsis, of course). > > Personally, I'm more inclined to implement the constraint as triggers, > since you can change the trigger as needed. In contrast, altering a > constraint in the table requires dropping and recreating the whole > table and data. As far as I know there's no disadvantage in > implementing constraints in triggers, but I'd like to know if that's > false. > > something like: > > create table MyTable( MyTextColumn ) > ; > create trigger MyTriggerInsert before insert on MyTable > begin > select raise(abort, 'MyTextColumn must contain only alphabetic > characters.') > where ltrim(new.MyTextColumn, > 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz') != ''; > end > ; > create trigger MyTriggerUpdate before update of MyTextColumn on MyTable > begin > select raise(abort, 'MyTextColumn must contain only alphabetic > characters.') > where ltrim(new.MyTextColumn, > 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz') != ''; > end > ; > > >> Another question I have is, has proper referential integrity been > >> finally established and things like full joins and other joins. > > Not directly, but you can also do this via triggers. > > I'd also like to know if support for foreign keys (defined in the > table) is planned for SQLite down the track. > > Tom > BareFeet > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _ Change the world with e-mail. Join the i’m Initiative from Microsoft. http://im.live.com/Messenger/IM/Join/Default.aspx?source=EML_WL_ChangeWorld ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite : text datatype and referential integrity
Igor, Thanks once again for your quick response. Sincerely, Palmer > To: sqlite-users@sqlite.org > From: [EMAIL PROTECTED] > Date: Mon, 19 May 2008 13:54:48 -0400 > Subject: Re: [sqlite] SQLite : text datatype and referential integrity > > palmer ristevski <[EMAIL PROTECTED]> > wrote: > > At first I thought that LTRIM you were refering to VB6, > > but then I noticed this is in a Create Table statement which then > > implied to me SQL stuff. > > I did a search and found that LTRIM is also a SQLite > > function/expression. Now is the expression 'check' also some > > predefined function in SQLite. > > Can you direct me to some resource on the web for this. > > http://sqlite.org/ > http://sqlite.org/docs.html > http://sqlite.org/lang.html > > Specifically, this is documentation on CREATE TABLE as implemented by > SQLite: > > http://sqlite.org/lang_createtable.html > > Note the CHECK constraint. Here's the list of built-in functions > supported by SQLite: > > http://sqlite.org/lang_corefunc.html > > Igor Tandetnik > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _ Keep your kids safer online with Windows Live Family Safety. http://www.windowslive.com/family_safety/overview.html?ocid=TXT_TAGLM_WL_Refresh_family_safety_052008 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite : text datatype and referential integrity
Thanks Igor! At first I thought that LTRIM you were refering to VB6, but then I noticed this is in a Create Table statement which then implied to me SQL stuff. I did a search and found that LTRIM is also a SQLite function/expression. Now is the expression 'check' also some predefined function in SQLite. Can you direct me to some resource on the web for this. Sincerely, Palmer > To: sqlite-users@sqlite.org > From: [EMAIL PROTECTED] > Date: Mon, 19 May 2008 13:25:53 -0400 > Subject: Re: [sqlite] SQLite : text datatype and referential integrity > > palmer ristevski <[EMAIL PROTECTED]> > wrote: > > Say one defines a column to be of text type, > > but you want only 'text' to contain only alphabetic characters, > > no numeric characters, how would one create this rule and enforce it > > in SQLite SQL or does one have to use triggers. > > Perhaps something like this: > > create table t(x check (ltrim(x, 'ABC...Zabc...z') = '')); > > (with full alphabet in place of ellipsis, of course). > > > Another question I have is, has proper referential integrity been > > finally established > > and things like full joins and other joins. > > No. Still no foreign keys, and only left outer joins. > > Igor Tandetnik > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _ E-mail for the greater good. Join the i’m Initiative from Microsoft. http://im.live.com/Messenger/IM/Join/Default.aspx?source=EML_WL_ GreaterGood ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] FW: SQLite : text datatype and referential integrity
From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: SQLite : text datatype and referential integrity Date: Sat, 17 May 2008 17:09:25 + Hi, Say one defines a column to be of text type, but you want only 'text' to contain only alphabetic characters, no numeric characters, how would one create this rule and enforce it in SQLite SQL or does one have to use triggers. Another question I have is, has proper referential integrity been finally established and things like full joins and other joins. I am fairly new to SQLite and in researching things I would find things about older versions of SQLite and then hear rumors that they have been fixed in the newer version, but I am not sure. Palmer E-mail for the greater good. Join the i’m Initiative from Microsoft. _ E-mail for the greater good. Join the i’m Initiative from Microsoft. http://im.live.com/Messenger/IM/Join/Default.aspx?source=EML_WL_ GreaterGood ___ 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
[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
