please unregister me
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On 13 Oct 2014, at 12:06pm, Rohit Kaushal rohitkausha...@gmail.com 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
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
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
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
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:
ARB
KEY
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
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
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
Rob yes thats correct
Igor - thanks I'll give that a go
On 16 May 2013 14:51, Rob Richardson rdrichard...@rad-con.com 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 guessing you
That worked thanks Igor.
On 16 May 2013 15:33, Paul Sanderson sandersonforens...@gmail.com wrote:
Rob yes thats correct
Igor - thanks I'll give that a go
On 16 May 2013 14:51, Rob Richardson rdrichard...@rad-con.com wrote:
First idea: include a subject line.
I'm not 100% clear on
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
On 31 Jan 2013, at 7:33pm, Paul Sanderson sandersonforens...@gmail.com 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.
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
On 31 Jan 2013, at 8:48pm, Paul Sanderson sandersonforens...@gmail.com 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, isgraphic,
On 31 Jan 2013, at 8:58pm, Simon Slavin slav...@bigfraud.org 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.
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 i...@tandetnik.org
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
Arbol One arbol...@gmail.com 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)
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
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
-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 are
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 the
-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 the
http://en.shijingsteel.com/pptlr.html
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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
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, db);
ie. does sqlite implement an alternative to f_lock
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,db);
Should
Nicholas Thompson nick.john.thomp...@googlemail.com 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, db);
Every time you connect to a :memory: database, a new
On Tue, Jun 12, 2012 at 8:32 AM, Igor Tandetnik itandet...@mvps.org wrote:
Nicholas Thompson nick.john.thomp...@googlemail.com wrote:
Is it possible to safely use multiple threads in a process with each
thread making
its own connection to the same database
rc =
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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.
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
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.
: Sunday, June 3, 2012 11:10 PM
Subject: [sqlite] Foreign key constraint failed
Hi all!
I have just recently discovered the strengths of foreign keys but now,
I've been banging my head against the wall for a couple of days.
I just can't figure out what is causing the error or how to get around
On 4 Jun 2012, at 6:39pm, Jörgen Hägglund jorgenhaggl...@netscape.net 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 the
On Fri, 25 May 2012 14:56:24 -0400, Frank Chang
frank_chan...@hotmail.com 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 Nuyt
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 main
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
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
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
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
On 2 May 2012, at 8:55am, Octet Computech dawitteg...@hotmail.com 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 getting
...@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 saves some data in a SQLite database. I am using SQLite v
a
href=http://avocat.prunelle.org/wp-content/plugins/extended-comment-options/02gfns.html;
http://avocat.prunelle.org/wp-content/plugins/extended-comment-options/02gfns.html/a
___
sqlite-users mailing list
sqlite-users@sqlite.org
a href=http://tourism.singapore18.com/wp-content/uploads/cache/02efpk.html;
http://tourism.singapore18.com/wp-content/uploads/cache/02efpk.html/a
___
sqlite-users mailing list
sqlite-users@sqlite.org
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,
On Wed, Jan 4, 2012 at 12:51 PM, Tarun er.tarun.9...@gmail.com 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
On Wed, 4 Jan 2012 17:21:18 +0530, Tarun er.tarun.9...@gmail.com
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 sqlite3_exec() in
Thanks,
Pratibha Kulkarni
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On 31 Aug 2011 at 23:24, Igor Tandetnik itandet...@mvps.org 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 happen is
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 insert
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 table in
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
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,
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 most one
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
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 your
On Thu, May 19, 2011 at 4:22 PM, Pavel Ivanov paiva...@gmail.com 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 strict type
On Thu, May 19, 2011 at 4:28 PM, Nico Williams n...@cryptonector.com 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 this.
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-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
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
On 21 Oct 2010, at 2:42pm, jbh...@bluefrog.com jbh...@bluefrog.com 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 mailing
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
, 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
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
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
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 from
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: General Discussion of SQLite
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
[mailto:sqlite-users-
boun...@sqlite.org] On Behalf Of e...@sitadella.com
Sent: Thursday, August 20, 2009 4:21 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] (no subject)
Hi guys,
This is my first post. I am creating a simple document archiving
program
for small businesses. I am creating
) before handing to SQLite.
Doug
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
boun...@sqlite.org] On Behalf Of e...@sitadella.com
Sent: Thursday, August 20, 2009 4:21 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] (no subject)
Hi guys
Hi Pavel,
´¯¯¯
So conversion between wchar_t and
UCS-2 encoding is not always as easy as you can think.
`---
Is there really anyone using UCS-2 now or did you mean UTF-16?
___
sqlite-users mailing list
sqlite-users@sqlite.org
Is there really anyone using UCS-2 now or did you mean UTF-16?
No, I meant exactly UCS-2. Because UCS-2 guarantees that all symbols
are represented by 2 bytes when UTF-16 does not. And I had an
understanding that Doug said about this 16-bit guarantee. Also if
we're talking about encoding where
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
boun...@sqlite.org] On Behalf Of e...@sitadella.com
Sent: Thursday, August 20, 2009 4:21 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] (no subject)
Hi guys,
This is my first post. I am creating a simple
´¯¯¯
No, I meant exactly UCS-2. Because UCS-2 guarantees that all symbols
are represented by 2 bytes when UTF-16 does not. And I had an
understanding that Doug said about this 16-bit guarantee. Also if
we're talking about encoding where any character can be represented by
a single variable of
Hi guys,
This is my first post. I am creating a simple document archiving program
for small businesses. I am creating it in a scripting language called
www.autohotkey.com. I intend to place the SQLite database file on a
network share and use sqlite.dll to access and manipulate it.
In general,
--
This message has been scanned for viruses and
dangerous content by Pinpoint, and is
believed to be clean.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
This message has been scanned for viruses and
dangerous content by Pinpoint, and is
believed to be clean.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
humm
--
ArbolOne.org specializes in Custom Web Site Design, Web Site Re Design, Web
Site Template Modifications, Web Site Maintenance, Integration of Payment
Gateways (API's), Database Applications, Custom Applications and much more.
416.838.2057
arbol...@gmail.com
O Allah, make my love for
Hello.
I'm using SQLite with a VB wrapper (dhSQLite) for VB6.
The following SQL string works fine for putting together a recordset where
the DATE field contains only the date of the last day of each month.
SQLString = SELECT date(Date,'start of month','+1 month','-1 day') as
Date, _
Hello.
I'm using SQLite with a VB wrapper (dhSQLite) for VB6.
The following SQL string works fine for putting together a recordset where
the DATE field contains only the date of the last day of each month.
SQLString = SELECT date(Date,'start of month','+1 month','-1 day') as
Date: Fri, 19 Jun 2009 14:53:05 -0700
From: Robert Lehr rl...@cadence.com
Subject: Re: [sqlite] async io and locks
To: sqlite-users@sqlite.org
In-Reply-To: 43c62cbb-57db-4d1b-af36-2facf239c...@gmail.com
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
I have never been able
Hi,
we are developing an application on android we are using SQLite Database
and on phone we are getting SQLiteException:no such table. but, it is
working fine on simulator.
Can anyone provide any input on this?
--
Thanks and Regards,
Manasi Save
Artificial Machines Pvt Ltd.
On Mon, 1 Jun 2009 04:38:37 -0700 (PDT), Manasi Save
manasi.s...@artificialmachines.com wrote:
Hi,
we are developing an application on android we are using SQLite Database
and on phone we are getting SQLiteException:no such table. but, it is
working fine on simulator.
Can anyone provide any
Hi All,
Can anyone help me out with the command to see the SQLite table defination
on command-line SQLite application.
--
Thanks and Regards,
Manasi Save
Artificial Machines Pvt Ltd.
manasi.s...@artificialmachines.com
Ph:- 9833537392
___
Hi,
select * from sqlite_master;
Martin
PS.: Please provide a subject which summarises your question.
Manasi Save schrieb:
Hi All,
Can anyone help me out with the command to see the SQLite table defination
on command-line SQLite application.
On Tue, May 26, 2009 at 4:45 PM, Martin.Engelschalk
engelsch...@codeswift.com wrote:
select * from sqlite_master;
Or:
.dump tablename
--
Samuel 'Shardz' Baldwin - staticfree.info/~samuel
___
sqlite-users mailing list
sqlite-users@sqlite.org
On 26/05/2009 7:58 PM, Samuel Baldwin wrote:
On Tue, May 26, 2009 at 4:45 PM, Martin.Engelschalk
engelsch...@codeswift.com wrote:
select * from sqlite_master;
Or:
.dump tablename
Don't try that with your 100MB database without ensuring that your
keyboard interrupt mechanism isn't seized
On Tue, May 26, 2009 at 6:34 PM, John Machin sjmac...@lexicon.net wrote:
Don't try that with your 100MB database without ensuring that your
keyboard interrupt mechanism isn't seized up :-)
Perhaps you meant
.schema tablename
I did indeed. I even remember going, oh, yeah, don't want dump in
Hi All,
I have the select statement as below
sqlite select remoteId, hostName , remoteWXType from remoteWXTable order by
hostName;
and the output is below:
1|HostName1-T432|2
2|HostName2-T421|2
3|HostName3-XP|2
4|HostName3-XP|2
But I would like the sql statement to return as below:
(HostName3
: Daniel Watrous dwmaill...@gmail.com
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent: Monday, February 2, 2009 11:55:52 AM
Subject: Re: [sqlite] (no subject)
Hey Boris,
It's a bit hard to follow what you've posted here, but I'm sure that's
because it came from a complicated
and
failed results as outlined before.
Thanks,
Boris
From: Daniel Watrous dwmaill...@gmail.com
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent: Saturday, January 31, 2009 5:42:40 PM
Subject: Re: [sqlite] (no subject)
why don't you
Hi,
I am having a small problem with an sqlite3 v3.5.6 database being accessed from
within python 2.5 (import sqlite3 as sqlite).
The database has been working correctly with the exception of the following
issue:
There are 17 tables with the first table being a dataset index table with three
why don't you send us some code. It sounds like you might have an
issue managing your connections.
On Sat, Jan 31, 2009 at 3:09 PM, Boris Arloff boris.arl...@yahoo.com wrote:
Hi,
I am having a small problem with an sqlite3 v3.5.6 database being accessed
from within python 2.5 (import
...@gmail.com
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent: Saturday, January 31, 2009 5:42:40 PM
Subject: Re: [sqlite] (no subject)
why don't you send us some code. It sounds like you might have an
issue managing your connections.
On Sat, Jan 31, 2009 at 3:09 PM, Boris
I have problem with executing this query in sqlite. to reconstruct problem
please follow the following steps.
1. create table awal1, akhir1 and hasil1 first.
CREATE TABLE awal1(Code char(5),Level varchar(8), Category varchar(50), Product
varchar(60), Location varchar(50), Begin datetime);
when iam using sqlite command prompt
Regards,
Satish
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of P Kishor
Sent: Friday, November 14, 2008 11:35 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] (no subject)
On 11/13/08
1 - 100 of 116 matches
Mail list logo