[sqlite] (no subject)

___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] (no subject)

Hi SQLite-users, I have in the console prg (cmd) created a small database in SQLite with only one table (just in order to check out SQLite). The Table is defined like this: CREATE TABLE IF NOT EXISTS "Gloser"( GRAESK VARCHAR(50) NULL, DANSK VARCHAR(50) NULL, LEKTION VARCHAR(10) NULL, NOTE TEXT

Re: [sqlite] (no subject)

On Mon, Jul 30, 2018 at 7:09 PM J Decker wrote: > > > On Mon, Jul 30, 2018 at 2:11 PM Keith Medcalf wrote: > >> >> >"SQLITE_ENABLE_LOCKING_STYLE=0","SQLITE_THREADSAFE=0", >> >"SQLITE_OMIT_UTF16","SQLITE_ENABLE_COLUMN_METADATA=1", >> >"SQLITE_DEFAULT_FOREIGN_KEYS=1" >> >> >Is there something

Re: [sqlite] (no subject)

On Mon, Jul 30, 2018 at 2:11 PM Keith Medcalf wrote: > > >"SQLITE_ENABLE_LOCKING_STYLE=0","SQLITE_THREADSAFE=0", > >"SQLITE_OMIT_UTF16","SQLITE_ENABLE_COLUMN_METADATA=1", > >"SQLITE_DEFAULT_FOREIGN_KEYS=1" > > >Is there something about the combination of options I've used? > > Do you get

Re: [sqlite] (no subject)

>"SQLITE_ENABLE_LOCKING_STYLE=0","SQLITE_THREADSAFE=0", >"SQLITE_OMIT_UTF16","SQLITE_ENABLE_COLUMN_METADATA=1", >"SQLITE_DEFAULT_FOREIGN_KEYS=1" >Is there something about the combination of options I've used? Do you get different results when using different options? (of course, if you turn

[sqlite] (no subject)

I have these options ... version 3.23.0. "SQLITE_ENABLE_LOCKING_STYLE=0","SQLITE_THREADSAFE=0","SQLITE_OMIT_UTF16","SQLITE_ENABLE_COLUMN_METADATA=1", "SQLITE_DEFAULT_FOREIGN_KEYS=1" This is the end of operations... It's starting to get an option...

[sqlite] (no subject)

On 7/12/18, danap wrote: >> I use a dump >> in my interface which I used with diff to compare changes in my >> personal expense database. This was to insure changes introduced in work >> on the interface were not screwing things up. Very helpful to insure >> your not introducing bugs. D. Richard

[sqlite] (no subject)

___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] (no subject)

On 2018/06/19 9:55 PM, Stephen Chrzanowski wrote: *sigh* I wish I had this kind of homework back in the day.. Well, I say you could just do the homework of those who do post homework questions here That way it technically IS your homework, and as such, your wish would have come

Re: [sqlite] (no subject)

*sigh* I wish I had this kind of homework back in the day.. On Tue, Jun 19, 2018 at 3:22 PM, Simon Slavin wrote: > On 19 Jun 2018, at 8:15pm, Vicente minguez gabarda > wrote: > > > hello I need a simple example of relationship between table, > > I would like to be able to visualize the

Re: [sqlite] (no subject)

On 19 Jun 2018, at 8:15pm, Vicente minguez gabarda wrote: > hello I need a simple example of relationship between table, > I would like to be able to visualize the relationship code between tables > and then reuse it. One day, just for a laugh, we should

[sqlite] (no subject)

hello I need a simple example of relationship between table, I would like to be able to visualize the relationship code between tables and then reuse it. thank you very much ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

[sqlite] (no subject)

Sent from Yahoo Mail on Android ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] (no subject)

Thanks I needed a Laugh, try clicking on one of the links at the bottom of your emails and unsubscribe. *Jim Dodgen* On Fri, Oct 6, 2017 at 7:41 PM, cindy estepp wrote: > stop emailing me i do not know you > ___ >

[sqlite] (no subject)

stop emailing me i do not know you ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] (no subject)

This seems to be exactly what I'm looking for. Thanks! --Ron Op ma 17 jul. 2017 om 20:23 schreef Jens Alfke > > > On Jul 17, 2017, at 11:08 AM, Ron wrote: > > > > I am looking into the possibility of putting the changes in SQLite > database > > into

Re: [sqlite] (no subject)

> On Jul 17, 2017, at 11:08 AM, Ron wrote: > > I am looking into the possibility of putting the changes in SQLite database > into kafka, similar to this: > https://www.confluent.io/blog/bottled-water-real-time-integration-of-postgresql-and-kafka/ > >

Re: [sqlite] (no subject)

I’d look at creating a virtual table that can be setup to “shadow” any existing table. Basically pass-through any read or write operations, possibly shunting off writes. This has the advantage of not requiring any kind of patching or modifications to the core library. Sounds a lot simpler

[sqlite] (no subject)

Hi, Before I dive into the SQLite internals, I'd like to ask the mailing list first. I am looking into the possibility of putting the changes in SQLite database into kafka, similar to this: https://www.confluent.io/blog/bottled-water-real-time-integration-of-postgresql-and-kafka/ . Would it be

[sqlite] (no subject)

[sqlite] (no subject)

On 10/03/2015 03:19 AM, Andrew Cunningham wrote: > > > SQLite uses a counter to enforce deferred foreign keys. Each time an > operation violates a constraint it increments that counter. > > If the counter is greater than 0, then for every operation that might > potentially correct

[sqlite] (no subject)

On 2015-10-03 01:51 PM, Dan Kennedy wrote: > > Ok. My first guess is that you are missing the "suggested index" on > the child table. Without this, if there is a foreign key violation in > the db, each insert on the parent table will cause a linear scan of > the entire child table. With the

[sqlite] (no subject)

> > > SQLite uses a counter to enforce deferred foreign keys. Each time an > operation violates a constraint it increments that counter. > > If the counter is greater than 0, then for every operation that might > potentially correct the violation (which means virtually every operation > on any

[sqlite] (no subject)

___ ?smail Keskin ismail.keskine at gmail.com cep : 0532 576 8488

[sqlite] (no subject)

Hello, I would like know the difference between SQLite and SQLite Manager, and how many bytes i can register in SQLite and SQLite Manager. Thanks.

[sqlite] (no subject)

On 11 Mar 2015, at 2:18pm, djamel slim wrote: > I would like know the difference between SQLite and SQLite Manager, SQLite is a tool for programmers to use. It allows for easy and flexible storage and retrieval of data. If you're just someone who uses programs, and not a programmer, you'll

[sqlite] (no subject)

from http://sourceforge.net/projects/sqlitemanager/ "SQLiteManager is a multilingual web based tool to manage SQLite database. The programming language used is: PHP4, but work fine with PHP5. Work just as well on a platform Linux as on Windows or MAC." from http://www.sqlite.org/ "SQLite is a

[sqlite] (no subject)

Please dnt spam my email

Re: [sqlite] (no subject)

On 13 Oct 2014, at 12:06pm, Rohit Kaushal wrote: > please unregister me Only you can stop forest fires. See the link at the bottom of every post to this list. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] (no subject)

please unregister me ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] (no subject)

http://recycling-it.com/wp-content/themes/health.google.php ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] (no subject)

On Tue, 1/28/14, Igor Tandetnik <i...@tandetnik.org> wrote: Subject: Re: [sqlite] (no subject) To: sqlite-users@sqlite.org Date: Tuesday, January 28, 2014, 2:41 PM On 1/28/2014 2:26 PM, David Bicking wrote: > I have two tables:

Re: [sqlite] (no subject)

On 1/28/2014 2:26 PM, David Bicking wrote: I have two tables: ARB KEY (PRIMARY KEY) ASSIGN (NOT NECESSARILY UNIQUE) DMC KEY (NOT UNIQUE) ASSIGN (NOT UNIQUE) VALUE I need to report all the records from ARB, and sum up the values if the keys match OR if the keys don't match, then sum

[sqlite] (no subject)

I have two tables: ARB KEY (PRIMARY KEY) ASSIGN (NOT NECESSARILY UNIQUE) DMC KEY (NOT UNIQUE) ASSIGN (NOT UNIQUE) VALUE I need to report all the records from ARB, and sum up the values if the keys match OR if the keys don't match, then sum up the values where the ASSIGN matches, but

Re: [sqlite] (no subject)

That worked thanks Igor. On 16 May 2013 15:33, Paul Sanderson wrote: > Rob yes thats correct > > Igor - thanks I'll give that a go > > > > On 16 May 2013 14:51, Rob Richardson wrote: > >> First idea: include a subject line. >> >> I'm not

Re: [sqlite] (no subject)

Rob yes thats correct Igor - thanks I'll give that a go On 16 May 2013 14:51, Rob Richardson wrote: > First idea: include a subject line. > > I'm not 100% clear on your message. You said: > " For those entries in table1 where there is a null in t2..." > I'm

Re: [sqlite] (no subject)

First idea: include a subject line. I'm not 100% clear on your message. You said: " For those entries in table1 where there is a null in t2..." I'm guessing you wanted to say: " For those entries in table1 where there is a null in t1..." Is that right? RobR

Re: [sqlite] (no subject)

On 5/16/2013 9:29 AM, Paul Sanderson wrote: I have two tables of the form create table1 (id1 int, t1 text) create table2 (id2 int unique, t2 text) For those entries in table1 where there is a null in t2 I want to copy the corresponding entry from table2 update table1 set t1=(select t2 from

[sqlite] (no subject)

I have two tables of the form create table1 (id1 int, t1 text) create table2 (id2 int unique, t2 text) the data in table 1 is such that some values for t1 are NULL ID1 can contain duplicates ID2 is unique and for every instance of ID1 in table1 there will be a corresponding ID2 entry in table2

[sqlite] (no subject)

Hi all Im getting the following exception when I try to open a connection to a SQLite db: System.TypeLoadException: Requested Windows Runtime type 'Sqlite.Sqlite3' is not registered. ---> System.Runtime.InteropServices.COMException: Class not registered (Exception from HRESULT: 0x80040154

Re: [sqlite] (no subject)

This makes a huge difference in speed thanks >>Also, you can write the query a bit more compactly: >>select fileref from rtable where vsc > 0 and isgraphic = 1 and md5 not in >>(select md5 from rtable where isgraphic = 1 and vsc = 0); On 31 January 2013 19:54, Igor Tandetnik

Re: [sqlite] (no subject)

On 31 Jan 2013, at 8:58pm, Simon Slavin wrote: > Depending on how chunky the values are in each column, a good index for this > would be an index on (md5,isgraphic,vsc). Sorry, that should be one index on (isgraphic,vsc), I think. Simon.

Re: [sqlite] (no subject)

On 31 Jan 2013, at 8:48pm, Paul Sanderson wrote: > Thanks all > > All columns in the query are indexed. That does not do you much good. Each SELECT can use only one index at a time. So if you have one index per column the query uses an index on, say,

Re: [sqlite] (no subject)

On 1/31/2013 2:33 PM, Paul Sanderson wrote: My query is select fileref from rtable as r where vsc > 0 and isgraphic = 1 and not exists (select md5 fr om rtable as r1 where r.md5 = r1.md5 and isgraphic = 1 and vsc = 0); explain query plan and explain have been run on the table with the results

Re: [sqlite] (no subject)

On 31 Jan 2013, at 7:33pm, Paul Sanderson wrote: > explain query plan and explain have been run on the table with the results > below. Any ideas where and how I can improve performance? Can you show us the indexes you've created on rtable ? Simon.

Re: [sqlite] (no subject)

On 09/05/2012 06:36 PM, Arbol One wrote: That would be the C++ Standard Template Library http://en.wikipedia.org/wiki/Standard_Template_Library I am learning the library and as a student I always have questions. The STL isn't necessarily a project, as it is defined in the C++ standard and

Re: [sqlite] (no subject)

Arbol One wrote: > Does anyone know if there is a mailing list for the STL project? Which of these do you mean by STL? http://en.wikipedia.org/wiki/Standard_Template_Library http://en.wikipedia.org/wiki/State_logic http://en.wikipedia.org/wiki/Subtitle_(captioning)

[sqlite] (no subject)

Does anyone know if there is a mailing list for the STL project? This e-mail is for the sole use of the intended recipient and may contain confidential or privileged information. Unauthorized use of its contents is prohibited. If you have received this e-mail in error, please notify sender

Re: [sqlite] (no subject)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 18/07/12 17:54, Jay A. Kreibich wrote: > Except that adds about 10x the workload for the moderators. I'd rather > have the SQLite team working on code, even if it means suffering the > occasional spam message. Who says the SQLite team have to be

Re: [sqlite] (no subject)

On Wed, Jul 18, 2012 at 02:10:52PM -0700, Roger Binns scratched on the wall: > On 18/07/12 13:00, Richard Hipp wrote: > > We have taken to requiring moderator approval before accepting new > > members onto this mailing list. > A better approach as used elsewhere (eg Google & Yahoo groups) is that

Re: [sqlite] (no subject)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 18/07/12 13:00, Richard Hipp wrote: > We have taken to requiring moderator approval before accepting new > members onto this mailing list. A better approach as used elsewhere (eg Google & Yahoo groups) is that the first ~10 messages from someone

Re: [sqlite] (no subject)

For the removal of doubt: We have taken to requiring moderator approval before accepting new members onto this mailing list. And even so spam like that shown below sometime leaks through. There is an arms race on, with spammers getting ever more sophisticated in their attacks. Sorry for the

[sqlite] (no subject)

http://en.shijingsteel.com/pptlr.html ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] (no subject)

Any one please tell me How to use triggers in sqlite using C... -- With Regards, *Bageesh.M.Bose* ** ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] (no subject)

On Tue, Jun 12, 2012 at 8:32 AM, Igor Tandetnik wrote: > Nicholas Thompson wrote: >> Is it possible to safely use multiple threads in a process with each >> thread making >> its own connection to the same database >> >> rc =

Re: [sqlite] (no subject)

Nicholas Thompson wrote: > Is it possible to safely use multiple threads in a process with each > thread making > its own connection to the same database > > rc = sqlite3_open("file::memory:?cache=shared", ); Every time you connect to a :memory: database, a

Re: [sqlite] (no subject)

On 06/12/2012 05:41 PM, Nicholas Thompson wrote: Hi, I am new to SQLITE Would be using Microsoft VS 2008& 2010 Is it possible to safely use multiple threads in a process with each thread making its own connection to the same database rc = sqlite3_open("file::memory:?cache=shared",); Should

[sqlite] (no subject)

Hi, I am new to SQLITE Would be using Microsoft VS 2008 & 2010 Is it possible to safely use multiple threads in a process with each thread making its own connection to the same database rc = sqlite3_open("file::memory:?cache=shared", ); ie. does sqlite implement an alternative to f_lock

[sqlite] (no subject)

___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] (no subject)

On Wed, Jun 6, 2012 at 1:08 AM, vallur raghava reddy < vallur.raghavare...@gmail.com> wrote: > Hi, > I have few queries regarding the SQLite. I have listed them below please go > through them and give your answers. Thanks > Say if I am working on a DB with 3 tables with 100 records each and each

Re: [sqlite] (no subject)

At 07:08 06/06/2012, you wrote: Hi, I have few queries regarding the SQLite. I have listed them below please go through them and give your answers. Thanks Say if I am working on a DB with 3 tables with 100 records each and each records with some 5 fields of data.Each field is varchar(20) 1.

[sqlite] (no subject)

Hi, I have few queries regarding the SQLite. I have listed them below please go through them and give your answers. Thanks Say if I am working on a DB with 3 tables with 100 records each and each records with some 5 fields of data.Each field is varchar(20) 1. What will be the Stack Size? 2.

Re: [sqlite] (no subject)

On 4 Jun 2012, at 6:39pm, Jörgen Hägglund wrote: > What I am trying to accomplish is an update from the source data. If the > entry is already there, just ignore it. Otherwise add the new data. If any unique key (including the primary key) of the existing row and

Re: [sqlite] (no subject)

(3.7.12.1) under SQLite Manager (Firefox / Iceweasel extension). If you need any further help, please let me know. Cheers. Stefanos From: Jörgen Hägglund jor...@sirlucifer.mine.nu To: sqlite-users@sqlite.org Sent: Sunday, June 3, 2012 11:10 PM Subject: [sqlite

Re: [sqlite] (no subject)

On Fri, 25 May 2012 14:56:24 -0400, Frank Chang wrote: > > http://swatim dot sw dot ohost dot de/gertycamp3.html Poisonous link, don't click. Frank, please perform a rigorous virus check on your machine(s), you may have been infected by a bot. -- Regards, Kees

Re: [sqlite] (no subject)

On 5/24/2012 11:46 AM, IQuant wrote: ie. I have a table with 1,000,000 + records collecting real time stats from many devices with many columns but the main ones of interest are 'timestamp', 'latency' and 'DeviceID'. 2012-05-01 13:12:11.103 Null 14356 2012-05-01 13:12:11.103 Null 14372

[sqlite] (no subject)

How can I construct a update query to calculate and set a record field "latency" with the difference between "timestamps" by "deviceid"? Appears sqlite doesn't support lag and lead. ie. I have a table with 1,000,000 + records collecting real time stats from many devices with many columns but the

[sqlite] (no subject)

http://www.appsfordevelopment.elimak.com/wp-content/themes/twentyten/7zcub9rd.php 5/7/2012 6:58:21 AM ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] (no subject)

http://www.appsfordevelopment.elimak.com/wp-content/themes/twentyten/7zcub9rd.php 5/7/2012 6:58:21 AM ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] (no subject)

lav...@bigfraud.org > Date: Wed, 2 May 2012 11:57:40 +0100 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] (no subject) > > > On 2 May 2012, at 8:55am, Octet Computech <dawitteg...@hotmail.com> wrote: > > > I have an application that creates > > and

Re: [sqlite] (no subject)

On 2 May 2012, at 8:55am, Octet Computech wrote: > I have an application that creates > and saves some data in a SQLite database. I am using SQLite v 3.6.14, > accessing > it through the native dll form a C# WPF application. For some reason that I > cant figure out am

[sqlite] (no subject)

Here is the problem that I am having with SQLite with encryption extension enabled, and I need help. I have an application that creates and saves some data in a SQLite database. I am using SQLite v 3.6.14, accessing it through the native dll form a C# WPF application. For some reason that

[sqlite] (no subject)

http://tourism.singapore18.com/wp-content/uploads/cache/02efpk.html;> http://tourism.singapore18.com/wp-content/uploads/cache/02efpk.html ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] (no subject)

http://avocat.prunelle.org/wp-content/plugins/extended-comment-options/02gfns.html;> http://avocat.prunelle.org/wp-content/plugins/extended-comment-options/02gfns.html ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] (no subject)

On Wed, 4 Jan 2012 17:21:18 +0530, Tarun wrote: >Hi All, > >I am running program in which I have created SQLite DB file using: >sqlite3_open_v2() > >configured it: > >PRAGMA journal_mode = WAL >PRAGMA synchronous=OFF > >Then created one table into SQLiteDB by using

Re: [sqlite] (no subject)

On Wed, Jan 4, 2012 at 12:51 PM, Tarun wrote: > Waiting for your response, I am stuck in my work. > The physical size of the db file is an implementation detail, not a well-published behaviour with concrete reproducible results, and should in no way affect your use of

[sqlite] (no subject)

Hi All, I am running program in which I have created SQLite DB file using: sqlite3_open_v2() configured it: PRAGMA journal_mode = WAL PRAGMA synchronous=OFF Then created one table into SQLiteDB by using sqlite3_exec() in which I passed SQL command of creating table. After configuration,

[sqlite] (no subject)

Thanks, Pratibha Kulkarni ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] (no subject)

On 31 Aug 2011 at 23:24, Igor Tandetnik wrote: > On 8/31/2011 5:56 PM, Tim Streater wrote: >> In the above, each database is newly created as shown. What I had >> forgotten to do was to create the "test" table in the second database >> before copying the data. What seems to

Re: [sqlite] (no subject)

On 8/31/2011 5:56 PM, Tim Streater wrote: In the above, each database is newly created as shown. What I had forgotten to do was to create the "test" table in the second database before copying the data. What seems to happen is that, lacking a "test" table in the test2 database, SQLite appears to

Re: [sqlite] (no subject)

On Wed, Aug 31, 2011 at 10:56:00PM +0100, Tim Streater scratched on the wall: > In the above, each database is newly created as shown. What I had > forgotten to do was to create the "test" table in the second > database before copying the data. What seems to happen is that, > lacking a "test"

[sqlite] (no subject)

Today when trying to copy from one database to another, I had the following error (simplified example below): Second-Mini% sqlite3 test1 sqlite> create table test (absid integer primary key, otherfield integer); sqlite> insert into test (absid,otherfield) values (null, 10); sqlite>

[sqlite] (no subject)

I am attempting to open an SQLite database on the Mac (OSX Snow Leopard) and am getting an error. This is the code I am using: char DBEnginePath[1000]; strcpy(DBEnginePath, "Macintosh HD:Applications:Adobe InDesign CS5:Plug-Ins:WPC_ID:IndexData.db"); fprintf(stderr, "%s\n",

Re: [sqlite] (no subject)

>Ah, there is a way to write it so that you can have at most one of >those constraints where only one makes sense, and not require a >specific order of constraints, but it'd require listing all the >possible orderings, which would be impractical. > >So if one wanted to enforce that there's at

Re: [sqlite] (no subject)

On Thu, May 19, 2011 at 4:28 PM, Nico Williams wrote: > However, I'm not sure how to write this such that there can be only > one of those constraints of which there should be just one but without > then imposing ordering on those constraints.  IMO there's no need to > fix

Re: [sqlite] (no subject)

On Thu, May 19, 2011 at 4:22 PM, Pavel Ivanov wrote: >> Is there a rationale for allowing such statements or is that an effect >> of the 'Lite' nature?  (Note: I'm not complaining, just asking.) > > I believe that's an effect of the "typeless" design. As SQLite doesn't > have

Re: [sqlite] (no subject)

> Is there a rationale for allowing such statements or is that an effect > of the 'Lite' nature?  (Note: I'm not complaining, just asking.) I believe that's an effect of the "typeless" design. As SQLite doesn't have strict type names for columns it accepts pretty much anything for that. So in

[sqlite] (no subject)

Anoher (silly) question about what SQLite considers valid input, again out of mere curiosity. A statement like: CREATE TABLE a (a CHAR COLLATE NOCASE COLLATE BINARY, b INTEGER DEFAULT 1 DEFAULT 2); doesn't cause any error: SQLite applies only the last constraint of each type, namely COLLATE

[sqlite] (no subject)

Hello All, I have been using SQLite for a couple of years but have never posted to this list before. I am sure my problem is common and am looking for ideas to solve it. I have used SQLite extensively single-threaded with no problems (other than my own!). I am currently working on another

[sqlite] (no subject)

___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] (no subject)

___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] (no subject)

On 21 Oct 2010, at 2:42pm, "" wrote: > please remove my name jbh...@bluefrog.com from the mailing list. Please click on the link included at the end of every message on this list. Simon. ___ sqlite-users

[sqlite] (no subject)

please remove my name jbh...@bluefrog.com from the mailing list. Thank you. 79 AE5IL John Houston www.rebuildinglostchurches.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] (no subject)

On Sat, 22 May 2010, Prakash Reddy Bande wrote: > Me too, all attempts to unsubscribe have failed. On Sat, 22 May 2010, pcvetsko...@yahoo.com wrote: > please unuscribed pcvetko...@yahoo.com Did you try this: http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Enter the email address

Re: [sqlite] (no subject)

, 2010 10:49 AM To: sqlite-users@sqlite.org Subject: [sqlite] (no subject) please unuscribed pcvetko...@yahoo.com, you insoult my mail, and i want to unuscribe for your contacts, thanx ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org

[sqlite] (no subject)

please unuscribed pcvetko...@yahoo.com, you insoult my mail, and i want to unuscribe for your contacts, thanx ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] (no subject)

Indeed, stupid typo in my sql. Sorry for the noise and the lack of a subject on the subject line in my first email. David --- On Tue, 10/27/09, Pavel Ivanov <paiva...@gmail.com> wrote: > From: Pavel Ivanov <paiva...@gmail.com> > Subject: Re: [sqlite] (no subject) > To

Re: [sqlite] (no subject)

Something screwed up in your application: sqlite> create table assets (Code Text, Acct1 Text, Acct2 Text); sqlite> insert into assets values ('C0', 'name1', 'name2'); sqlite> select * from assets; C0|name1|name2 sqlite> insert into assets select 'C0', 'name1', 'name3' where not exists (select 1

[sqlite] (no subject)

I have a table ASSETS with fields (Code Text, Acct1 Text, Acct2 Text). (There are other fields, and the primary key is a combination of 5 columns) For one code ('C0') I want to implement a rule that if I attempt to insert a combination of 'C0'/Acct1/Acct2 it will be ignored if the first two keys

[sqlite] (no subject)

Hi, (SQLite v3.6.17, on ARM with Linux 2.6.18) I'm currently investigating the applicability of SQLite in an embedded application. Part of this would be to store configuration data, for which SQLite seems like a natural fit. I also have a requirement for exchange of realtime data between

  1   2   >