the next version of SQLite3.
John G
On Wed, 26 Feb 2020 at 19:09, Jean-Luc Hainaut
wrote:
> On 26/02/2020 12:18, Richard Hipp wrote:
> > On 2/26/20, Jean-Luc Hainaut wrote:
> >> Hi all,
> >>
> >> It seems that SQLite (version 31.1) accepts a trigger declara
numbers into the "VALUE" column, it will fail.
--
People in sleeping bags are the soft tacos of the bear world.
Maranatha! <><
John McKown
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
error "too many fields"
}
}
}
dbcmd eval $SQL {
puts [format "Field %-15s on %-15s has the string %-15s: %s" $cn $tn
$searchstr $val]
}
Field t0c on table0 has the string plus : 2
plus 2 equals 4
Field t12 on table1
read or process. The
function does not have an event loop. The function does not have its
own stack. The function (with its subfunctions) does all the work
itself, using the callers stack, then returns control to the caller.
So what do I call this, if I can no longer use the word "serverless&
e "serverless" should not be your problem.
Just my pennies worth,
John
On 28/01/2020 09:18, Richard Hipp wrote:
For many years I have described SQLite as being "serverless", as a way
to distinguish it from the more traditional client/server design of
RDBMSes. "Serverless
current
documentation. I leave finding it as an exercise for the reader.
John
-Original Message-
From: sqlite-users On Behalf Of
John McKown
Sent: Monday, November 25, 2019 9:51 AM
To: SQLite mailing list
Subject: Re: [sqlite] Shell commands for controlling headers
On Mon, Nov
with something in the past.
--
People in sleeping bags are the soft tacos of the bear world.
Maranatha! <><
John McKown
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
s it on, I go
into the library and read a good book
-- Groucho Marx
Maranatha! <><
John McKown
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Or without the added calories (syntactic sugar) :
select a.*, b.*
from author_books ab, author a, books b
where a.author_id = ab.author_id
and b.book_isbn = ab.book_isbn
On Tue, 27 Aug 2019 at 15:52, David Raymond
wrote:
> It does support natural joins. changes" comments here>
>
> USING n
is.
>
> --
> D. Richard Hipp
> d...@sqlite.org
--
This is clearly another case of too many mad scientists, and not enough
hunchbacks.
Maranatha! <><
John McKown
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
I have an Arduino/Python experiment that generates lots of simple numerical
data; about 7000 records a day. I run it through Python into an sqlite3
database.I have been running this for 8 months. I start a new database about
every six weeks so every database has about 260k rows. I have one
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--
Regards
John McMahon
li...@jspect.fastmail.fm
___
sqlite-users mailing list
sqlit
On 10/04/2019 18:28, Kees Nuyt wrote:
On Wed, 10 Apr 2019 13:17:23 +1000, John wrote:
I have not used extensions before. I understand that some are included
in the amalgamation source file and that some of these are enabled by
default. So, which ones are built-in and which of those are
activate it?
John
--
Regards
John McMahon
li...@jspect.fastmail.fm
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
te3_snprintf()' processes the strings 'szName' and
'szCondition' to verify they do not contain escape sequence that may inject
other SQL statements into this statement?
Thanks!
John
___
sqlite-users mail
around all data is saved, but all
follwing calls to 'sqlite3_backup_step()' do not save anything.
My question:
Is there a way to use this online-backup system in an incremental way: that it
will save only difference from last time BUT ALL the difference from last time?
Many th
Hi,
I read in SQLite documentation that if I define column of type INTEGER PRIMARY
KEY then this column will become an alias to SQLite internal 64-bit integer
index that uniquely identifies the row (hence ‘rowid’).
I also read that the initial default value that will be used for such column is
-bit SQLite DLL for Windows
(sqlite-dll-win64-x64-326.zip),
3. Or, build my data-layer code with SQLite code as a single DLL.
Thanks in advanced,
John
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org
erate .csv files in my desired format.
# gpsbabel XCSV style file
#
# Format: G7toWin csv format
# Author: John McMahon
# Date: 2005may24
# Update: 2006jun02jmcm
#
DESCRIPTION G7toWin csv file format
#
# FILE LAYOUT DEFINITIONS
#
FIELD_DELIMITER COMMA
RECORD_DELIMITER NEWLIN
If I missed i tin earlier posts, sorry. Is there any documentation on the
geopoly extension? With possible uses or examples?
John
On Thu, 29 Nov 2018 at 14:39, Richard Hipp wrote:
> On 11/29/18, Thomas Kurz wrote:
> > Could it be that the one angle is north-based, the other one e
Recently figured this out. Seems to work fine
trim(trim(round(1.111,0),'0'),'.') = 1
Aviso de Privacidad y Confidencialidad // Privacy and Confidentiality Notice //
Avis de confidentialit?: https://privacy.grupobimbo.com/
__
Lite implementation?
>
>
> Regards,
> Clemens
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--
John Found
_
On Fri, 12 Oct 2018 08:27:10 +0200
Clemens Ladisch wrote:
> John Found wrote:
> > i.e. how to select only the groups that contain
> > some value in the set of values in a column not
> > specified in group by clause.
> >
> > select
> > (select grou
specified in group by clause.
The only way I was able to do it is by subquery.
Something like this:
select
(select group_concat(b) from t t1 where t1.a = t2.a) as list
from t t2
where b = ?1;
--
John Found
___
sqlite-users mailing list
In that same JSON page, in 1. Overview the text mentions '12 of 14 SQL
functions' but the listing shows different numbers - 13 numbered items in
the first section, 2 in the second, numbered 1 - 15.
Should that be "twelve of the *fifteen* SQL functions" or "*thirteen* of
the *fifteen* SQL functio
arly, if you need the result columns to have certain names, you must
> provide these via AS clauses.
>
> -Ursprüngliche Nachricht-
> Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im
> Auftrag von John Found
> Gesendet: Sonntag, 16. September 2018 10:30
On Sun, 16 Sep 2018 10:59:31 -0400
Richard Hipp wrote:
> On 9/16/18, John Found wrote:
> >
> > Is it means that in every query that uses GROUP BY and ORDER BY
> > simultaneously, one of the operations will always be provided by using
> > temporary b-tree?
> >
&g
oup by and order by simultaneously
without using temp b-tree?
On Sun, 16 Sep 2018 10:59:31 -0400
Richard Hipp wrote:
> On 9/16/18, John Found wrote:
> >
> > Is it means that in every query that uses GROUP BY and ORDER BY
> > simultaneously, one of the operations w
On Sun, 16 Sep 2018 13:30:55 +0100
Simon Slavin wrote:
> On 16 Sep 2018, at 9:29am, John Found wrote:
>
> > Is there some relation between the indexes used in the query, the GROUP BY
> > fields used
> > and the order of the result rows, when no "ORDER BY"
ays the tradeoff of library size & cycles to optimise vs execution cycles
> saved to consider).
>
> > On 16 Sep 2018, at 6:29 pm, John Found wrote:
> >
> > Is there some relation between the indexes used in the query, the GROUP BY
> > fields used
> > an
o2
NULL 5 300
f,g 3 200
c,d,e 2 50
a,b1 100
--
John Found
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
On Wed, 5 Sep 2018 10:42:04 +0200
"E.Pasma" wrote:
> John Found wrote:
> > In order to write an autoupdater, I need to download the latest SQLite
> > amalgamation.
> > Is there a permanent link to the subject, or the only way is to parse the
> > d
In order to write an autoupdater, I need to download the latest SQLite
amalgamation.
Is there a permanent link to the subject, or the only way is to parse the
download page
for links to "sqlite-amalgamation-*.zip" or to build it from the fossil
checkout?
--
uirement for stack alignment on 16 bytes,
regardles of that it was compiled to 32bit code. On the other hand, my code
aligns the stack on 4 bytes as an usual 32bit program.
The option -mpreferred-stack-boundary=2 fixed the issue.
--
John Found
_
200 (supports almost
all extensions), gcc version is 8.2.0;
BTW, compiling with -O1 sometimes produces working result (but pretty slow)
which only entagles the puzzle.
--
John Found
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http
(my gcc and generally
C/C++ skills are pretty low) or I somehow messed the options elsewhere. Then
what to check?
--
John Found
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo
On Thu, Aug 30, 2018 at 11:12 AM Don V Nielsen
wrote:
> "Having successfully ported sqlite to z/OS Unix as a 32 bit app"
>
> Totally Awesome! Do I have a solution? No. But I'll bet John McKown will. I
> believe he is a guru with the mainframe.
>
I don't kn
My thinking is along the line of all mission critical clocks take their
accuracy from the US Naval Observatory in Fort Collins, CO, instead of
thousands of free running clocks, each with what it thinks is the
correct time.
John
On 08/03/2018 02:48 AM, Ling, Andy wrote:
another point that I di
have to be updated when the computers are back at the office.
John
On 08/02/2018 11:33 AM, Igor Korot wrote:
Hi,
On Thu, Aug 2, 2018 at 1:27 PM, John R. Sowden
wrote:
I made a mistake. I should have said table, not database. My concern is if
I have 4 databases each with tables associated
e with the master in order to stay current.
I do this now because I have 1 account number index and the various
foxpro databases (tables) all open that one index when each is used.
John
On 08/02/2018 10:31 AM, Simon Slavin wrote:
On 2 Aug 2018, at 6:11pm, John R. Sowden wrote:
I do not
assume that I would have to reindex
each database each time it is opened, since a record could have been
edited, etc.
tia,
John
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman
> > "subCategory" COLLATE NOCASE ASC, "startTime" COLLATE NOCASE ASC);
> > CREATE UNIQUE INDEX "Disruptions_Idx2" ON Disruptions ("Disruption_id"
> > COLLATE NOCASE ASC, "version" COLLATE NOCASE ASC, "category" COLLATE
&g
count_down where n > 0
...> )
...> select * from count_down;
Error: no such column: n
should have been (replacing 'n' with 'v'):
sqlite> with recursive count_down(v) as (select 5 union all select v - 1
from count_down where v > 0)
...> select * from count
On Wed, 2018-06-13 at 21:42 +1000, Gary R. Schmidt wrote:
>
>
> This is an increasing problem, and has been discussed on the Mailman
> mailing list recently, you should join them and see what mitigation
> strategies are available.
Well I'm sure he would like to, but subscriptions have probably
Very good point. I think that everyone should do it that way. It is a bit
more work, but is vastly superior.
On Mon, Jun 11, 2018, 03:23 Olivier Mascia wrote:
> > Le 11 juin 2018 à 10:07, Peter Nacken a écrit :
> >
> > I try to insert email addresses into a table and get an error with
> address
lite3 database.db3
sqlite> .read FILENAME
sqlite> .quit
This would mirror the PostgreSQL supplied psql command. For whatever that
is worth.
--
We all have skeletons in our closet.
Mine are so old, they have osteoporosis.
Maranatha! <><
John McKown
_
On Tue, 2018-05-08 at 11:40 +0200, Olivier Mascia wrote:
> > Le 8 mai 2018 à 09:37, Domingo Alvarez Duarte
> > a écrit :
> >
> > Hello Richard !
> >
> > Again this list is getting spammed, I just received spam after
> > publish.
> >
> > Cheers !
>
> Technically, it is not the list which gets s
ipedia.org/wiki/Abstraction_(computer_science)>
>
>
>
> --
> Sent from: http://sqlite.1065341.n5.nabble.com/
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/
as per the explanatory note. I was just
bringing to attention what I thought was an inconsistency in the
documentation.
John
On 05/04/2018 06:25, David Raymond wrote:
Looks like when it goes and makes the table it doesn't give it an explicit "blob" type,
as you would thi
string)
In the Expression Affinity table above, should the Expression Affinity
'NONE' be updated to 'BLOB' possibly with the explanatory 'Historical
note:' as per section '3. Type Affinity' in datatypes.html above.
NOTE: I have checked the curr
0
(Out of 3 databases. )
On 16 March 2018 at 15:37, Richard Hipp wrote:
> This is a survey, the results of which will help us to make SQLite faster.
>
> How many tables in your schema(s) use AUTOINCREMENT?
>
> I just need a single integer, the count of uses of the AUTOINCREMENT
> in your overal
On Sat, 10 Mar 2018 01:17:38 +
Simon Slavin wrote:
> On 9 Mar 2018, at 7:49pm, John Found wrote:
>
> > In the current implementation "insert or replace" behave as the foreign
> > constraint is deferred.
> > But according to documentation, all
On Fri, 9 Mar 2018 19:42:19 +
Simon Slavin wrote:
> On 9 Mar 2018, at 7:11pm, John Found wrote:
>
> > "insert or replace" succeed without deleting the old rows from B.
>
> "replace" means "delete the original row, then insert a new one"
al. At least this was my
expectation when writing the code.
--
http://fresh.flatassembler.net
http://asm32.info
John Found
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Hello,
My team is working on a project that involves transmitting sensor data from a
data logger module to a mobile application via Bluetooth. I am interested in
finding a relatively fast, reliable way to store the data that was collected by
the data logger. Since we aren't guaranteed to alway
ol can load.
>
> —Jens
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
I have a theory that it's impossible to prove anythin
s because of the "USE TEMP B-TREE FOR ORDER BY".
Order by any field
other than "rank" and "rowid" makes this query very slow.
> On Thu, Feb 8, 2018, 7:14 PM John Found, wrote:
>
> >
> > I am using FTS5 for pretty complex search in my application, b
ain question follows:
What is the right way to design such complex search systems, based on FTS? How
to properly approach the sorting of the search results in order to not have so
big slowdowns and out of memory errors.
Any tips are highly welcome!
Regards
--
http://fresh.flatas
On Mon, 2018-02-05 at 09:39 -0800, Jens Alfke wrote:
> > On Feb 5, 2018, at 9:21 AM, Drago, William @ CSG - NARDA-MITEQ > liam.dr...@l3t.com> wrote:
> >
> > The reliable part is easy because there is enough information on
> > the SQLite website about testing, but what about security?
>
> Open so
rds to use william.dr...@l3t.com.
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--
http://fresh.flatassembler.net
http://asm32.info
John Found
___
synthesized query for every particular case.
>
> -Ursprüngliche Nachricht-
> Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im
> Auftrag von John Found
> Gesendet: Montag, 05. Februar 2018 15:55
> An: sqlite-users@mailinglists.sqlite.org
> Bet
be good).
But what are the disadvantages of such approach? (except the bigger database
size, of course)
On Mon, 5 Feb 2018 09:24:51 -0500
Richard Hipp wrote:
> On 2/5/18, John Found wrote:
> > The following query:
> >
> > explain query plan
> > select
>
idxPostsThreadUser on Posts(threadid, userid);
IMHO, the change of the selected columns should not affect the query plan, but
maybe I am wrong somehow.
What I am missing?
--
http://fresh.flatassembler.net
http://asm32.info
John Found
___
sqlite-users mailing
__
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
I have a theory that it's impossible to prove anything, but I can't prove
it.
Maranatha! <><
John McKow
quick test with the command "type
x.txt" where "x.txt" contained "abc~def" (where ~ is standing in for 0x1a)
resulted in my seeing "abc". But "notepad x.txt" shows "abc def". So I
guess it depends on how o
I've not tried it, but this article from OSXdaily says you can get the
command line (Terminal) in iOS.
http://osxdaily.com/2018/01/08/get-terminal-app-ios-command-line/
That probably does not solve the fork requirement, and I'm sure it is
sandboxed.
John G
On 15 January 201
Sqlite Shell:
On Linux, using .output and .mode csv, sqlite produces a [dos] 1L, 161C
file. Is this a bug or is it a compile issue for my distribution to
address?
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists
Thanks Warren. Sorry about that, I had an old version in /opt/local/bin.
John Gillespie
On 11 January 2018 at 15:24, Warren Young wrote:
> On Jan 11, 2018, at 5:47 AM, John G wrote:
> >
> > Is this because I am stuck with version 3.8.8.3 which is what MacOS
> Sierra
> &
_
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--
http://fresh.flatassembler.net
http://asm32.info
John Found
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
agma_table_info(ObjectName)
...> );
Error: near "(": syntax error
Is this because I am stuck with version 3.8.8.3 which is what MacOS Sierra
provides?
I see you were using 3.22.
John Gillespie
On 6 January 2018 at 20:02, Keith Medcalf wrote:
> Full Schema Tables:
>
geable C++ programmer, but wouldn't a simple:
extern C {
...
... SQLite definitions
...
}
be a way to do it?
Or maybe I'm simplifying your question too much (wouldn't be the first time
for me).
>
> Cheers,
>
--
I have a theory that it's impossible to prove anyt
d use Word
Perfect and Lotus 1-2-3 back in the MS-DOS days. But today's users want a
word process which is WYSIWYG and want their spreadsheets to create pretty
*π* charts.
>
> ---
> The fact that there's a Highway to Hell but only a Stairway to H
ne off" for every SCM that they
want to support. IMO, that would be very short sighted.
--
I have a theory that it's impossible to prove anything, but I can't prove
it.
Maranatha! <><
John McKown
___
sqlite-users mailing list
If you don't have Tcl/Tk ... if you are using MacOS or Linux you already
have it.
On Windows you can download it from https://www.activestate.com/activetcl
John G
On 14 December 2017 at 12:19, advancenOO
wrote:
> Hello Richard,
>
> I hope to run some tests by myself and I thin
On Tue, Dec 12, 2017 at 12:34 PM, Mark Wagner wrote:
> My reading of https://sqlite.org/syntax/select-core.html makes me think
> that I should be able to issue something like values('foo'); and get a row
> with a single column whose value is 'foo'. But I get a syntax error.
>
> Probably obvious
On Fri, Dec 8, 2017 at 12:54 PM, John Mount wrote:
> I am seeing an issue where a random value in a sub-query gets re-generated
> each time the value is used in later queries. Below is an example query:
>
> SELECT r AS r1, r AS r2 FROM ( SELECT random() AS r FROM ( SELECT * from
.
---
John Mount
http://www.win-vector.com/ <http://www.win-vector.com/>
Our book: Practical Data Science with R http://www.manning.com/zumel/
<http://www.manning.com/zumel/>
___
sqlite-users mailing list
sqlite-users@mailinglists.sql
Fascinating article.
Thanks.
John Gillespie
On 4 December 2017 at 13:08, Simon Slavin wrote:
> Every so often someone asks on this list for Unicode to be handled
> properly. I did it myself. Then other people have to explain how hard
> this is. So here’s an article which, after int
't in ColorScheme
> table. The PriorityLevel and PriorityText would be returned as NULL.
>
> Does anyone have any working theories on how I can get ALL results in the
> Events table regardless if the Events.Priority isn't in
> ColorScheme.PriorityLevel?
>
I agree - keep the list on email. Simple, convenient.
John Gillespie
On 22 November 2017 at 19:49, Niall O'Reilly wrote:
> On 21 Nov 2017, at 16:27, Drago, William @ CSG - NARDA-MITEQ wrote:
>
> > Please, not a forum. The email list is instant, dynamic, and convenient.
> I
> Hauppauge, NY 11788
> 631-272-5947 / william.dr...@l3t.com
>
--
I have a theory that it's impossible to prove anything, but I can't prove
it.
Maranatha! <><
John McKown
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
rtions into, perhaps:
$PWD/bld/tcl8.6/sqlite3
I don't know if the action that I saw is intentional or not.
--
I have a theory that it's impossible to prove anything, but I can't prove
it.
Maranatha! <><
John McKown
___
sqlite-users
thank you. i think there are too many errors in this guide for me to
use it.
John
On 10/22/2017 09:03 PM, Keith Medcalf wrote:
There are a number of syntax errors.
Line 1 - You have an / that should not be there.
Line 6 - You cannot call a module, only a function in a module (not strictly
^C./sqlite3_test.py: line 7: syntax error near unexpected token `('
./sqlite3_test.py: line 7: `connection = sqlite3.connect(':memory:')'
john@sentry35:~$
On 10/22/2017 08:44 PM, Simon Slavin wrote:
connection = sqlite3.connect(&#x
I just checked my file with a hex editor (ghex) and found they are all
hex 27.
John
On 10/22/2017 08:27 PM, Simon Slavin wrote:
On 23 Oct 2017, at 4:13am, John R. Sowden wrote:
error from terminal program:
./sqlite3_test.py: line 6: syntax error near unexpected token
i just switched to python3 - no difference in error
On 10/22/2017 08:13 PM, John R. Sowden wrote:
error from terminal program:
./sqlite3_test.py: line 6: syntax error near unexpected token `('
./sqlite3_test.py: line 6: `connection = sqlite3(':memory:')'
john@sentry3
error from terminal program:
./sqlite3_test.py: line 6: syntax error near unexpected token `('
./sqlite3_test.py: line 6: `connection = sqlite3(':memory:')'
john@sentry35:~$
version 2.7.12 (ubuntu 16,04 lts)
John
On 10/22/2017 08:07 PM, Igor Korot wrote:
Hi, John,
On
, (2,'bar'), (3,'baz') ] )
# print inserted rows
for row in connection.execute('select * from events'):
print(row)
---
can anyone tell me where i am missing something?
John
___
sqlite-users mailing list
sq
lite_master where type = 'table'
and name = '$name';";
# stmt only executed once, $name only evaluated once
my ($tableexists) = $dbh->selectrow_array($sql);
# selectrow returns 1 row, the stmt returns 1 element in list context
return $tableexists;
}
my $chec
I know this is an older thread, but shouldn't that reference be on the ITEM
table ? So ...
CREATE TABLE ATTRIBUTES (
ITEM_ID INTEGER REFERENCES ITEM(ID) ON DELETE CASCADE,
KEY TEXT,
VALUE TEXT,
PRIMARY KEY (ITEM_ID,KEY)
) WITHOUT ROWID;
John G
On 11 September 2017 at
umbs to point
> me in the correct direction.
>
> regards, Robert
>
>
--
*L'Shanah Tovah Tikatevu*
Maranatha! <><
John McKown
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
that can strike after long
time on the database schema change.
>
> Thanks.
>
> --
> Cecil Westerhof
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--
http://fresh.flatassembler.net
http://asm32.info
John Found
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
g
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
Caution! The OP is an hyperpolysyllabicsesquipedalianist and this email may
cause stress to those with hippopotomonstrosesquipedaliophobia.
Maranatha! <><
John McKown
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> insert into x values('2017-09-04', 4);
sqlite> select count(*) from x;
5
sqlite> select count(*) from x where a is NULL;
2
sqlite> select count(*) from x where a is NOT NULL;
3
sqlite>
--
Caution! The OP is an hyperpolysyllab
Thank you all for your feedback. I now have a lot more to digest. I
will investigate the attach command. I am concerned about keeping all
of my company's data in 1 file, as if something happened to that file, I
would have data entry, programming, etc. to on all systems since the
last backup,
itive Guide to SQLite_ by Michael
Owens, but I'm early in the book.
Help?
John
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
ned out
to be the cause of a long-sought bug in some of my own code.
Hopefully, just this report might save someone else similar grief.
Key phrases:
interprocess database-locking, pragma busy_timeout, database is locked
Thanks!
John B.
___
sqlite-use
sing Fire Fox and Thunderbird.
> ArbolOne is composed of students and volunteers dedicated to providing
> free services to charitable organizations.
> ArbolOne on Java Development in progress [ í ]
>
> ___
> sqlite-users mailing list
> s
ishing for.
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated traffic volume.
-Original Message-
From: sqlite-users [mailto:sqlite-users-
boun...@mailinglists.sqlite.org] On Behalf Of John McMahon
Sent: Monday, 21 August, 2017 2
On 22/08/2017 16:41, Clemens Ladisch wrote:
John McMahon wrote:
UPDATE CUSTOMERS as c
SET
cust1= (select customer from test where custnum = c.custnum),
cust2= NULL,
street = (select address from test where custnum = c.custnum),
town = (select town from
1 - 100 of 2794 matches
Mail list logo
