Re: [sqlite] importing data to sqlite from stdin

2009-06-29 Thread palmer ristevski
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

[sqlite] Question about Referential IntegrityRE: Foreign key support

2009-02-09 Thread palmer ristevski
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

Re: [sqlite] best language match for SQLite?

2008-09-16 Thread palmer ristevski
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!

Re: [sqlite] best language match for SQLite?

2008-09-16 Thread palmer ristevski
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

Re: [sqlite] best language match for SQLite?

2008-09-16 Thread palmer ristevski
"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:

Re: [sqlite] best language match for SQLite?

2008-09-16 Thread palmer ristevski
"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

Re: [sqlite] Proposed removal of (mis-)feature

2008-08-07 Thread palmer ristevski
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

Re: [sqlite] text datatype and referential integrity

2008-05-19 Thread palmer ristevski
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

Re: [sqlite] SQLite : text datatype and referential integrity

2008-05-19 Thread palmer ristevski
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 <[EMAI

Re: [sqlite] SQLite : text datatype and referential integrity

2008-05-19 Thread palmer ristevski
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

[sqlite] FW: SQLite : text datatype and referential integrity

2008-05-19 Thread palmer ristevski
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

Re: [sqlite] Hello I am a newbie : for SQLite : Create db : VB6

2008-04-29 Thread palmer ristevski
! 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

[sqlite] Hello I am a newbie : for SQLite : Create db : VB6

2008-04-29 Thread palmer ristevski
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