5.6.6
Pete Campion
Cell : +27 82 447 8989
Bus : +27 31 572 2354
Fax : +27 86 6484 678
<mailto:ssw...@iafrica.com> mailto:pe...@ssware.co.za
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists
Thanks you Jay and other for the clarification. The fact that the table
can only have one column is what was missing from my understanding of how
this works.
Jay, I think you just persuaded me to buy your book!
Pete
On Tue, May 1, 2012 at 9:00 AM, wrote:
> Message: 5
> Date: Mon, 30 Ap
Anyone?
-- Forwarded message --
From: Pete
Date: Thu, Apr 26, 2012 at 10:55 AM
Subject: Expression syntax
To: sqlite-users@sqlite.org
The syntax diagram for an expression using the IN/NOT IN operators shows an
option to specify database.tablename as the right operand. What
The syntax diagram for an expression using the IN/NOT IN operators shows an
option to specify database.tablename as the right operand. What does
database.tablename evaluate to?
--
Pete
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
Hi TIm,
sqlite3 already includes the ability to define the width manually with the
.width command. I was hoping that there might be a way to use the defined
string length as part of the default when .width is not used.
Pete
On Thu, Apr 26, 2012 at 9:00 AM, wrote:
> Nothing to stop you add
Re: [sqlite] sqlite3 column widths
> Message-ID: <4f97106d.7080...@rogerbinns.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 24/04/12 13:26, Pete wrote:
> > Is there way to have sqlite3 display the col
Is there way to have sqlite3 display the columns in the result of a SELECT
statement using their defined widths in the schema? For example if a
column is defined as "Name(40) TEXT", I want the column to be 40 chars wide.
--
Pete
___
sq
and formatting dates.
>
> --
> Best regards, Alexey Pechnikov.
> http://pechnikov.tel/
>
--
Pete
Molly's Revenge <http://www.mollysrevenge.com>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ents to csv file handling. I seem to
remember there were issues with embedded commas and single quotes - is that
one of the areas of improvement?
Thanks,
Pete
On Sat, Apr 14, 2012 at 9:00 AM, wrote:
> Message: 12
> Date: Fri, 13 Apr 2012 17:53:01 -0400
> From: Richard Hipp
> To:
doesn;t seem to cover the new
feature.
Thanks,
--
Pete
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
The
solution is per Michael's later reply which is :
INSERT into t3 (Col1) SELECT Col1 FROM t2;
Thanks to everyone for the solution.
Pete
On Thu, Apr 5, 2012 at 9:00 AM, wrote:
> Message: 10
> Date: Thu, 5 Apr 2012 01:38:57 +0100
> From: Simon Slavin
> To: General Discuss
Thank you Michael, that works.
Pete
On Thu, Apr 5, 2012 at 9:00 AM, wrote:
> Message: 17
> Date: Thu, 5 Apr 2012 12:31:58 +
> From: "Black, Michael (IS)"
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Variation on INSERT with SELECT issue
>
Thank you Igor and Simon, I think I understand this now. On reading the
docs more closely, it looks like the scond test case (NOT NULL with a
DEFAULT) could be solved by using INSERT OR REPLACE. I'm wondering if
there might be a way to solve the first test case by using a trigger?
Pete
O
The test this time was:
sqlite> create table t1 (Col1,Col2);
sqlite> insert into t1 (Col1) values ('xxx');
sqlite> select * from t1;
xxx|
sqlite> create table t2 (Col1, col2 not null default 'abc');
sqlite> insert into t2 SELECT * from t1;
SQL error
;);
insert into t3 SELECT * FROM t2;
select * from t3;
xxx|
Why does t3.Col2 not have it's default value of 'abc'?
Pete
--
Pete
Molly's Revenge <http://www.mollysrevenge.com>
___
sqlite-users mailing list
sqlite-users@sqli
since I don't access to
compilers (or the skills to use them).
Thanks,
Pete
On Tue, Apr 3, 2012 at 9:00 AM, wrote:
> Message: 5
> Date: Mon, 2 Apr 2012 17:58:28 +0100
> From: Simon Slavin
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Foreign Key P
s setting only applies for the life of
a db connection and they have to be enabled every time a db is opened. Is
that correct? Do all PRAGMA settings work like that?
Thanks,
Pete
On Mon, Apr 2, 2012 at 9:00 AM, wrote:
> Message: 12
> Date: Mon, 02 Apr 2012 15:33:20 +0700
> From
Thanks Pavel and Dan, that was the problem. In the past, I've always used
a primary key as the parent of a foreign key link so hadn't run into this
issue.
Pete
On Mon, Apr 2, 2012 at 9:00 AM, wrote:
> Message: 12
> Date: Mon, 02 Apr 2012 15:33:20 +0700
> From: Dan Kennedy
O t2 VALUES ('a','aaa');
I get a foreign Key mismatch error. No matter what value I supply for
FKeyColumn, even NULL, I get the same error.
I disabled foreign keys, then the INSERT worked. Enabled foreign keys
again, it fails again.
And even more concerning "DELETE
Interesting. Does that mean any open transaction other than the VACUUM
transaction? I'm still confused.
Pete
On Tue, Mar 27, 2012 at 9:00 AM, wrote:
> Message: 5
> Date: Mon, 26 Mar 2012 10:25:49 -0700 (PDT)
> From: Peter Aronson
> To: General Discussion of SQLite Databa
SHould a VACUUM command be wrapped in a transaction, or is that done
automatically?
--
Pete
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
that might be? The longer times are still very fast but I'm
curious to know if there are some ways of retrieving data that are faster
than others for the same query.
Thanks
--
Pete
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://
multiple constraint
violations occur. Maybe that would change depending on the ON CONFLICT
action specified?
I guess all I can do is add my vote to the list of people who would like
improvements to the way constraint violations are reported, perhaps with a
PR
ld be used in
a CHECK constraint, but it feels like I would be duplicating built in
constraints if I do that, e.g CHECK (Col1 IS NOT NULL) for a NOT NULL
constraint.
Thanks,
--
Pete
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.o
otice there is no space in the column name listed in
the error message".
I'm not unduly concerned since this column name should never have had a
space in it in the first place but perhaps CREATE TABLE should flag an
error in this situation if the column can't be accessed?
--
Thanks, probably a foreign key would handle the example I gave. I'm
really asking the general question what is possible within the CHECK
constraint? Is it possible to base the check on a SELECT statement on
another table?
Pete
In the example, what I am trying to check is if the value o
ssible to do this in a CHECK statement and perhaps I need to use a
trigger instead.
Thanks,
--
Pete
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
OK, back to square 1 then I guess.
Pete
On Fri, Feb 17, 2012 at 9:00 AM, wrote:
> Message: 8
> Date: Thu, 16 Feb 2012 21:44:36 -0500
> From: "Igor Tandetnik"
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Incorporating user written functions into the
>
I just noticed the load_extension(x) core function that seems like it would
solve this problem since I can name the library file to be loaded.
Pete
On Thu, Feb 16, 2012 at 9:00 AM, wrote:
> Message: 1
> Date: Wed, 15 Feb 2012 09:38:43 -0800
> From: Pete
> To: sqlite-users@sqlite.o
rrect value to the primary key field. IS this expected behavior?
--
Pete
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Thanks. I'll check on that but I'm not optimistic.
Pete
On Wed, Feb 15, 2012 at 9:00 AM, wrote:
> Message: 7
> Date: Tue, 14 Feb 2012 19:16:33 +0100
> From: Stephan Beal
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Incorporating user w
idea how to set about making them available to the sqlite3 library in
the framework. Any help on how to make these user written functions
available to the sqlite3 library in the framework would be much appreciated.
Thanks
--
Pete
___
sqlite-users ma
o to get a list
of the columns in a temp table?
Thanks,
--
Pete
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Thanks Larry. I had always been under the impression that forward slashes
weren't acceptable in Windows path names so I'm glad to hear they are. The
project I'm working on has to run on Macs as well as Windows and the
forward slash is acceptable on both platforms.
Pete
On Tue, Ja
I'm not sure if this is an sqlite3 question or WIndows.
I am trying to use the .output command to send the output from a SELECT
statement to a file on WIndows 7. The .output command looks like:
.output C:\Users\Pete\AppData\Local\Temp\sqlite3out.txt
When the SELECT statement is execute
I think you misunderstood my question. I simply want to run sqlite3 on
Windows to create a database and use it's other functionality, not call it
from another application. My question is simply what is the conventional
place to put it on a Windows computer.
Pete
> Message: 10
> Da
ory should this be installed in? If you haven't already guessed from
the question, I'm not vey familiar with WIndows!
--
Pete
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
multiple table/column pairs?
--
Pete
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
If I create an index for a column in a table with existing data in it, is
the index automatically populated or do I have to use the REINDEX command?
Thanks,
--
Pete
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin
I may not have searched diligently enough but I can't find any information
about the purpose of the foreign key MATCH keyword. Is it documented
somewhere?
Thanks,
--
Pete
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:808
Opinions on the best one for OS X?
Pete
> Message: 6
> Date: Sat, 05 Nov 2011 15:46:36 -0500
> From: John Horn
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] sql server management studio like tool for
>SQLite
> Message-ID: <4eb5a0
Thanks for the information and the VIEW suggestion.
Since SQLite already provides an extension to reference column aliases in
WHERE and JOIN clauses, is there any likelihood that it might be further
extended to allow them in the SELECT statement itself?
Thanks,
Pete
> Message: 14
>
that correct?
Pete
> --
>
> Message: 11
> Date: Fri, 28 Oct 2011 16:34:15 -0400
> From: Igor Tandetnik
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Referring to column alias
> Message-ID:
> Content-Type: text/plain; charset=UTF-8;
I have another variation of this issue:
SELECT col1 - col2 as Total, Total * price FROM tst
.. gives an error " no such column: Total". I can just repeat "col1 - col2"
of course, but wondering if there is a way to refer to Total within the
SELECT.
Thanks,
Pete
> &g
Thanks Alex, that seems to work fine. One of the results that I got was on
Nabble so looks like you can go to Nabble and search there to.
Pete
On Thu, Oct 27, 2011 at 11:17 AM, Alek Paunov wrote:
> This was said above in the thread - try this google query:
>
> site:mail-ar
The one attraction of a forum to me is that it's searchable so I'd be able
to check for any discussions before posting to the mailing list. Is there an
archive for the mailing list somewhere which could serve the same prupose?
Pete
--
>
> Message: 27
Pete
Molly's Revenge <http://www.mollysrevenge.com>
Thanks Kee, that explains it.
>
> Message: 6
> Date: Sun, 23 Oct 2011 21:02:07 +0200
> From: Kees Nuyt
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] sqlite-users Digest, Vol 46, Issue 23
> Message
Apologies, I omitted what is the real cause of the problem. This simplified
SELECT illustrates the error:
SELECT sum( colc * cold ) as total from tst where total > 1000
The error message is "misuse of aggregate: sum()". No error if I remove the
where clause.
Pete
>
>
statement other than in the AS clause? If not, is there any other
way to achieve this without repeating the sum expression?
Pete
Molly's Revenge <http://www.mollysrevenge.com>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8
would just
create the DB and exit
Pete Helgren
Value Added Software, Inc
www.asaap.com
www.opensource4i.com
On 8/30/2011 8:14 PM, Simon Slavin wrote:
Forgot to mention: copying an existing database file also lets you set up the
file the way you want without having to issue separate commands. F
mpt, waiting for
commands. Hence that option is a non-starter.
Pete Helgren
Value Added Software, Inc
www.asaap.com
www.opensource4i.com
On 8/30/2011 8:23 PM, Jay A. Kreibich wrote:
Of course, I'm not sure what the big deal is. By default, if you
attempt to open an SQLite database f
a Linux guy so the scripting might be wrong.
Pete Helgren
Value Added Software, Inc
www.asaap.com
www.opensource4i.com
On 8/30/2011 7:38 PM, Simon Slavin wrote:
On 31 Aug 2011, at 2:36am, Pete Helgren wrote:
I have a need to create a database if it doesn't already exist. The obvious
pt so that I know the database exists before
issuing other commands.
I searched around the Internet for what I thought would be an easy
answer and didn't find one. I am running SQLite 3.3.13 from BusyBox 1.1.3
Thanks
--
Pete Helgren
Value Added Software, Inc
www.asaap.com
www.openso
How can I store and retrieve data in the equivalent of mySQL's BINARY
datatype? The collation sequence doesn't matter in this instance. Is BLOB
the appropriate sqlite datatype?
Pete
___
sqlite-users mailing list
sqlite-users@sqlit
Thanks Igor. I assume your comment about the two queries not returning the
same results is because the LEFT JOIN query would return TableA rows with no
matching TableB rows, whereas the Scalar query would not. How could I
change the scalar query to emulate the LEFT JOIN query?
Pete
TableB ON
TablebB.indexcolumn = TableA.primarykeycolumn
OR
SELECT column1, (SELECT column2 FROM TableB WHERE TableB.indexcolumn =
TableA.primarykeycolumn) FROM TableA
Thanks,
Pete
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080
Thanks Michael, that solves the problem.
Pete
Message: 1
> Date: Sun, 26 Jun 2011 12:01:43 +
> From: "Black, Michael (IS)"
> Subject: Re: [sqlite] Substring question
> To: General Discussion of SQLite Database
> Message-ID: <71635118-DC41-416E-AE85-F788177B
tr function requires
specific character positions - is there a way to do this?
Pete
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
tr function requires
specific character positions - is there a way to do this?
Pete
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hear, hear! We're all capable of making our own decisions. Last time I
looked, the title of this forum was General Discussion of SQLIte database,
hopefully we can get back on topic.
Pete
> Message: 26
> Date: Mon, 6 Jun 2011 01:26:54 +0100
> From: Simon Slavin
> Subject:
On 2011-04-30, at 13:36, Jos Groot Lipman wrote:
> The rounding problem is documented in the FAQ:
> http://www.sqlite.org/faq.html#q16
That reference does not address the issue of the four rounding modes
of the Intel FPUs. SQLite being a library rather than a process, does
SQLite control the
5
[apparent gap]
00:02:10
00:03:15
00:03:45
[apparent gap]
00:05:10
then the sampling point would be better placed on 30 second boundaries
instead of zero second boundaries. In this case the integer division
function DIV must be modified to account for the offset, as must the
SELECT query.
Re
I would like to offer suggestions to help the original poster to solve
the problem, but my lack of diction makes me unable to word my
questions and suggestions in the right manner for this forum.
Kindest regards to you all,
Pete
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On 2011-04-13, at 15:25, Richard Hipp wrote:
> On Wed, Apr 13, 2011 at 9:53 AM, Pavel Ivanov
> wrote:
>
>>> The fact that one engineer installed a site, began operating the
>>> app,
>>> then saw it become corrupt minutes later rules out power loss or
>>> hard
>>> resets in at least that ca
Yes, I already figured out what the problem was. I was asking for a
solution. The SELECT scalar query gets me what I wanted.
Pete
Molly's Revenge <http://www.mollysrevenge.com>
> Message: 1
> Date: Fri, 8 Apr 2011 08:17:22 -0400
> From: "Igor Tandetnik"
&g
Thanks Pavel, that works.
Pete
Molly's Revenge <http://www.mollysrevenge.com>
On Fri, Apr 8, 2011 at 4:36 AM, Pavel Ivanov wrote:
> Probably this could work:
>
> SELECT c1,c2,sum(t2.c3) / count(distinct t3.rowid),count(distinct t3.rowid)
> FROM t1 LEFT JOIN t2 on t2.k
qualifying entries, the calculation for the
other table is correct.
I guess GROUP BY isn't designed to deal with this type of situation. Can
anyone suggest a way to do this?
Thanks,
Pete
___
sqlite-users mailing list
sqlite-users@sqlite.org
67 matches
Mail list logo