7;where custnum = c.custnum' clauses.
I came across some Web examples that suggest that I might not. I haven't
tested yet and am a little unsure.
Any guidance would be appreciated.
John
--
Regards
John McMahon
li...@jspect.fastmail.fm
___
to write all their code in a
"baby" language like BASIC until they learn better. Either that or have
their fingers broken.
--
Veni, Vidi, VISA: I came, I saw, I did a little shopping.
Maranatha! <><
John McKown
___
sqlite-users maili
imal64/src/parse.y .
Cheers !
Thank you Domingo, but that option is beyond my programming competence.
On 06/07/17 05:16, John McMahon wrote:
Hi
Wondering if someone else can spot the syntax error in the following
statement. "locns" is an attached database. There are four "AS
e not the same as the updated table).
--
˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı
-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
On Behalf Of John McMahon
Sent: Wednesday, 5 July, 2017 21:17
To: SQLite Users
Subject: [sqlite] syntax erro
On 06/07/2017 16:33, Clemens Ladisch wrote:
John McMahon wrote:
an alias for an "UPDATE" table name is not permitted. Is there a particular
reason for this?
The UPDATE statement affects a single table. While an alias might be
a convenience, it is not necessary (any naming co
error message if they are not the same as
the updated table).
--
Regards
John McMahon
j...@jspect.fastmail.com.au
04 2933 4203
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
imal64/src/parse.y .
Cheers !
Thank you Domingo, but that option is beyond my programming competence.
On 06/07/17 05:16, John McMahon wrote:
Hi
Wondering if someone else can spot the syntax error in the following
statement. "locns" is an attached database. There are four "AS
On 06/07/2017 16:33, Clemens Ladisch wrote:
John McMahon wrote:
an alias for an "UPDATE" table name is not permitted. Is there a particular
reason for this?
The UPDATE statement affects a single table. While an alias might be
a convenience, it is not necessary (any naming co
e not the same as the updated table).
--
˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı
-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
On Behalf Of John McMahon
Sent: Wednesday, 5 July, 2017 21:17
To: SQLite Users
Subject: [sqlite] syntax erro
error message if they are not the same as
the updated table).
--
Regards
John McMahon
j...@jspect.fastmail.com.au
04 2933 4203
--
Regards
John McMahon
li...@jspect.fastmail.fm
___
sqlite-users mailing list
sqlite-user
rmitted. Is there a particular reason for this?
I would think it a convenience especially when using long table names
and attached databases.
John
sqlite> UPDATE locns.xxx_last_delivery AS tgt
... > SET
... > tgt.del_date = (
... > SELECT src.last_del_
achine (Honeywell) which had a 36 bit word which was divided
into 9 bit "bytes" (i.e. an address pointed to a 9 bit "byte").
--
Veni, Vidi, VISA: I came, I saw, I did a little shopping.
Maranatha! <><
John McKown
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
com/developerworks/community/blogs/e0c474f8-3aad-4f01-8bca-f2c12b576ac9/entry/IBM_zEnterprise_redundant_array_of_independent_memory_subsystem
?
--
Veni, Vidi, VISA: I came, I saw, I did a little shopping.
Maranatha! <><
John McKown
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
t;mkdir bld # make directory ./bld
x>cd bld
x/bld>../sqlite/configure
x/bld> # up to directory x, then down in into directory sqlite & run
configure residing there
x/bld> # results of configure are put in this directory
--
Veni, Vidi, VISA: I came, I saw, I did a little shoppi
BM to come up with a data
encryption standard and they came up with ...
Student: EBCDIC!
Maranatha! <><
John McKown
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
m PostFTS where PostFTS match ?1 ThreadID:?2;
--
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
0.
What I am missing? Or such behavior is normal and expected.
--
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
this personally.
John
On 17/05/2017 19:07, no...@null.net wrote:
The current '%W' week substitution appears to be US-specific. I would
like to make a feature request for a '%V' (or similar) substitution
that inserts the ISO-8601 week number.
--
Regards
John McMahon
On Tue, 2 May 2017 09:38:30 +0200
Olivier Mascia wrote:
> > Le 2 mai 2017 à 09:00, John Found a écrit :
> >
> > What is the best way (less CPU consuming) to put a thread in sleep and wake
> > it up when new record has been written to a given table of SQLite dat
want both. :)
--
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
so, would periodic WAL checkpoints help?
>
> —Jens
> ___
> 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
Joh
ailinglists.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
PRAGMA foreign_keys=1 is transient, but it would be nice if it were
persistent.
John G
On 13 April 2017 at 12:35, Tony Papadimitriou wrote:
> -Original Message- From: no...@null.net
>
>> What would be useful (at least via the shell CLI) is a "list_pragmas"
&g
ic.
Thank you.
John
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
ultiple
concurrent users". Just my opinion, of course. Others may reasonably
disagree.
--
Our calculus classes are an integral part of your education.
Maranatha! <><
John McKown
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
; as it is normally programmed).
--
There’s no obfuscated Perl contest because it’s pointless.
—Jeff Polk
Maranatha! <><
John McKown
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
2
sqlite> select length(testtext) from testit;
401
sqlite>
--
There’s no obfuscated Perl contest because it’s pointless.
—Jeff Polk
Maranatha! <><
John McKown
___
Loved that explanation. I could easily understand it.
On Jan 19, 2017 17:14, "James K. Lowden" wrote:
> On Wed, 18 Jan 2017 23:36:14 +
> Peter Haworth wrote:
>
> > if I include a WHERE claus, the view's ORDER BY clause is ignored and
> > the rows are returned in seemingly random order.
> >
empty string, then the
> value of each column is stored in a variable with the same name as the
> column itself.
>
Perhaps a warning could be added like "The case of the variable is the same
as in the table definition unless a column alias is used."
John Gillespie
___
Sent from Yahoo Mail on Android
From:"Richard Hipp"
Date:Mon, Sep 5, 2016 at 2:52 PM
Subject:Re: [sqlite] 3rd Call For Papers - 23rd Annual Tcl/Tk Conference
(Tcl'2016)
On 9/5/16, akupr...@shaw.ca wrote:
>
> Hello SQLite Users, fyi ...
>
> 23rd Annual Tcl/Tk Conference (Tcl'2016)
> ht
Sent from Yahoo Mail on Android
From:"Scott Robison"
Date:Tue, Sep 6, 2016 at 1:16 PM
Subject:Re: [sqlite] "Responsive" website revamp at www.sqlite.org
Lamding page looks fine on my Galaxy Note 4 phone and cheap Amazon Fire
tablet, both landscape and portrait. Documents by category doesn't li
;,1);
sqlite> insert into info(ident, price) values('a1',1);
sqlite> insert into info(ident, price) values('b',2);
sqlite> insert into info(ident, price) values('c',3);
sqlite> select min(price), ident from info;
1|
sqlite> select price, ident from info where
org/wiki/Decimal_floating_point
>
> Thanks,
> Chris
>
--
Heisenberg may have been here.
Unicode: http://xkcd.com/1726/
Maranatha! <><
John McKown
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Thank you!
John
On 11/22/2016 01:21 PM, R Smith wrote:
On 2016/11/22 6:00 PM, John R. Sowden wrote:
That was a throw back to years ago. I was trying to protect against
y2k by making each dbf for 1 calendar year. Also, these files are
about 800k in size, so I was worried about storage
iliar with. In the mean time I am reading the Sqlite mail
list, understanding about 40% of it. There seems to be a lot of sql
tutorials on the web. W3schools seems to be popular, so I am trying it.
John
On 11/22/2016 08:30 AM, Igor Korot wrote:
John,
On Tue, Nov 22, 2016 at 11:00 AM, J
databases. Sometimes over the last 45 years I have changed
the dbf structure. This way I only change starting at the year in
question, then change the program to work with the structure modification.
John
On 11/22/2016 12:33 AM, Christoph P.U. Kukulies wrote:
Just a thought about your TABLE
Thank you all for your answers and direction for further information.
Hopefully, I will not bring these subjects up again. :)
John
On 11/21/2016 09:29 AM, John R. Sowden wrote:
First of all, I come from the dBASE/Foxpro world. There is no
distinction between a table and a database. I
w how long each record should
be, same with integers.
No help found in the documentation on the Sqlite web site.
John
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Thanks, that worked.
John Gillespie
On 8 November 2016 at 14:30, Richard Hipp wrote:
> On 11/8/16, John G wrote:
> > I normally use the 3.8.8.3 supplied with MacOS El Capitan.
> > I downloaded version 3.15.1 from the Download page - precompiled
> > command-line tools :
ignored everything after the first
line. This is not the case with 3.8.8.3.
If I put ALL the statements on a single long line they are accepted.
Is this a bug? Am doing something wrong? Tongue in wrong position?
Thanks for any help.
John Gillespie
Text in my editor:
create table people (pid
I've submitted a ticket,
https://system.data.sqlite.org/index.html/tktview?name=d4728aecb7, and want to
add a
comment to it. I can't find any obvious way to do it in the ticket page (I'm
logged on as
anonymous). Is it possible?
-John
_
ays
loads
Mono.Data.SQLite under Mono, but allows you to specify that System.Data.SQLite
should be
loaded regardless of whether the platform is .NET or Mono:
http://fsprojects.github.io/SQLProvider/core/sqlite.html#SQLiteLibrary
/John
> There are various compile-options and extensions b
en the
columns. This appears, to me, to be a rather simple change in shell.c.
> dvn
>
>
--
Heisenberg may have been here.
Unicode: http://xkcd.com/1726/
Maranatha! <><
John McKown
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
1) Can't see the 'attachment' - this list does not accept them.
Can you copy/paste sample code into an email?
John G
On 31 August 2016 at 14:34, Maria de Jesus Philadelpho <
jesus.ph...@gmail.com> wrote:
> Hi,
>
> I implement the SQLite extension, virtcsv, which
this is that you can run the exact same code on Windows
and Mono+Linux without resorting to using the rarely updated
Mono.Data.SQLite package (about 1.5 years old right now, and with
unfixed bugs critical to my application).
My question is: what are the trade-offs of not using SQLite
Thanks Scott for that explanation.
John
On 11/09/2016 01:27, Scott Robison wrote:
On Sep 10, 2016 2:54 AM, "John McMahon" wrote:
On 08/09/2016 10:09, Bob McFarlane wrote:
Please reply if you sent this. Thanks.
Hmm, looks like a fishing exercise to me. Same message in sever
On 08/09/2016 10:09, Bob McFarlane wrote:
Please reply if you sent this. Thanks.
Hmm, looks like a fishing exercise to me. Same message in several threads.
This reply only to mailing list.
John
-Original Message-
From: sqlite-users [mailto:sqlite-users-boun
others too.)
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
Klein bottle for r
; Regards,
> Michael.j.Falconer.
>
--
Klein bottle for rent -- inquire within.
Maranatha! <><
John McKown
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
ion-3.14.0
It is not in the "trunk" branch right now. And it appears to be available
on this page: http://sqlite.org/download.html
--
Klein bottle for rent -- inquire within.
Maranatha! <><
John McKown
___
sq
On Tue, 26 Jul 2016 21:52:26 +0100
Simon Slavin wrote:
>
> On 26 Jul 2016, at 9:29pm, John Found wrote:
>
> > Is it possible to use SQLite, making queries directly in the internal
> > virtual machine language, instead of SQL?
> >
> > Or in another variant, c
On Tue, 26 Jul 2016 16:40:07 -0400
Richard Hipp wrote:
> On 7/26/16, John Found wrote:
> > Is it possible to use SQLite, making queries directly in the internal
> > virtual machine language, instead of SQL?
>
> No. Why do you want to do this. The SQL language is the most
://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
,
and it seems that sqlite3 and Pure Basic or Gambas is a good match for
me. I need multiple indices, support for about 5000 records, plus some
very small ones for validation, etc.
Can anyone direct me to some complete documentation.
Thanks, John
quot;. Isn't it?
--
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
imes, because they're sure that something won't be right.
Optimistic people check once, trust in Solis-de to keep the ship safe, then
blow everyone up."
"I think you're mistaking the word optimistic for inept."
"They've got a similar ring to my ear."
From
mism is a admirable quality in an engineer. Pessimistic people check
their work three times, because they're sure that something won't be right.
Optimistic people check once, trust in Solis-de to keep the ship safe, then
blow everyone up."
"I think you
why I am using netbook class PCs and 5..10 years old desktop machines
for testing my applications.
--
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
already delivered mass mailing. Can't be
done.
--
The unfacts, did we have them, are too imprecisely few to warrant our
certitude.
Maranatha! <><
John McKown
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mail
I don't see the '.dbinfo' command in the shell in the version supplied
with MacOS X 10.10 (Yosemite) - 3.8.8.3.
Was this introduced after this.
I know Apple is a bit slow in updating, but I can't use a personally
compiled verion.
John G
On 5 May 2016 at 23:42, R Smith
ase matches
> efficiently?
>
?how about: SELECT group_concat(user,"|") FROM os_users GROUP BY
upper(user) HAVING count(*) > 1
??
>
> Thanks, --DD
>
--
The unfacts, did we have them, are too imprecisely few to warrant our
certitude.
Maranatha! <><
John McKown
>
> Thank you.
>
> P.S.: This is a rhetorical question, BTW.
>
>
--
The unfacts, did we have them, are too imprecisely few to warrant our
certitude.
Maranatha! <><
John McKown
On Fri, Apr 29, 2016 at 12:41 PM, Igor Korot wrote:
> Hi,
>
> On Fri, Apr 29, 2016 at 1:28 PM, John McKown
> wrote:
> > On Fri, Apr 29, 2016 at 12:00 PM, Jann Roder
> > wrote:
> >
> >> Hi,
> >> It seems like a too obvious omission to not be
n the SUM(A).
>
> Jann
>
--
The unfacts, did we have them, are too imprecisely few to warrant our
certitude.
Maranatha! <><
John McKown
e of a dilettante programmer. ?But this
last is how I think of ?using SQLite. I use for permanent storage, in
preference to reading regular file and putting the data into something like
a Java Hashmap.
>
>
> Cheers,
> Ryan
>
--
"He must have a Teflon brain -- nothing sticks to it"
Phyllis Diller
Maranatha! <><
John McKown
lication will not know of it and thus not use it.
> As I see it, it is as with partial indexes. That is a big change (I think),
> but it did not break backward compatibility.
>
>
--
"He must have a Teflon brain -- nothing sticks to it"
Phyllis Diller
Maranatha! <><
John McKown
On Thu, 14 Apr 2016 13:57:20 -0400
Richard Hipp wrote:
> On 4/14/16, Richard Hipp wrote:
> > On 4/14/16, John Found wrote:
> >> But after some time working in wild (executing the more complex original
> >> query), the performance decreased again and despite of existi
On Thu, 14 Apr 2016 09:19:06 -0400
Richard Hipp wrote:
> On 4/14/16, John Found wrote:
> >
> > But after some time working in wild (executing the more complex original
> > query), the performance decreased again and despite of existing the index,
> > the result of
On Thu, 14 Apr 2016 13:44:45 +0200
R Smith wrote:
>
>
> On 2016/04/14 10:46 AM, John Found wrote:
> > Playing with optimization of my queries, I stuck on very strange (for me)
> > behaviour of
> > sqlite.
> >
> > The query is pretty complex, bu
an be the reason for such strange behaviour?
--
http://fresh.flatassembler.net
http://asm32.info
John Found
So, I am searching for the way to make it without changing the whole SQL query.
P.S. BTW another issue that I can't solve with fts5 is returning posts that
does not contain some word.
"NOT keyword" does not work at all, neither "* NOT keyword";
--
http://fresh.flatassembler.net
http://asm32.info
John Found
On Wed, 13 Apr 2016 23:38:04 +0700
Dan Kennedy wrote:
> On 04/13/2016 11:24 PM, John Found wrote:
> > What FTS5 query should I use in order to match all rows in the table?
> >
>
> Can you use "SELECT * FROM fts_table;"?
>
*I* can. But the users of the progr
What FTS5 query should I use in order to match all rows in the table?
--
http://fresh.flatassembler.net
http://asm32.info
John Found
join_table_with_view
CREATE TABLE join_table_with_subselect AS SELECT C.A FROM C INNER JOIN
(SELECT * FROM D) D ON D.A=C.A;
.schema join_table_with_subselect
Output:
CREATE TABLE join_two_tables(A);
CREATE TABLE join_table_with_view("C.A");
CREATE TABLE join_table_with_subselect("C.A");
join_table_with_view
CREATE TABLE join_table_with_subselect AS SELECT C.A FROM C INNER JOIN
(SELECT * FROM D) D ON D.A=C.A;
.schema join_table_with_subselect
Output:
CREATE TABLE join_two_tables(A);
CREATE TABLE join_table_with_view("C.A");
CREATE TABLE join_table_with_subselect("C.A");
On Sat, 26 Mar 2016 16:08:33 +0100
Eduardo Morras wrote:
> On Sat, 26 Mar 2016 16:37:18 +0200
> John Found wrote:
>
> > Why cannot drop the table test?
> >
> > sqlite> begin transaction;
> > sqlite> create virtual table test using fts5;
> > Erro
tent test_docsize
test_config test_data test_idx
$sqlite3 --version
3.11.1 2016-03-03 16:17:53 f047920ce16971e573bc6ec9a48b118c9de2b3a7
--
http://fresh.flatassembler.net
http://asm32.info
John Found
so the program wouldn't fit into? memory.
And, the ever popular:
END OF FILE ON UNIT 05 AT RUN TIME
--
How many surrealists does it take to screw in a lightbulb? One to hold the
giraffe and one to fill the bathtub with brightly colored power tools.
Maranatha! <><
John McKown
-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
A fail-safe circuit will destroy others. -- Klipstein
Maranatha! <><
John McKown
gt; create table one(one int);
sqlite> insert into one values(1);
sqlite> create table two (two text);
sqlite> insert into two values('two');
sqlite> select * from one;
1
sqlite> select * from two
...> ;
two
sqlite> insert into one values('ugly');
sqlite> select * from one;
1
ugly
sqlite> .quit
~/projects/sqlite-test$
exit
logout
Script done on Mon 08 Feb 2016 03:07:41 PM CST
===?
--
The man has the intellect of a lobotomized turtle.
Maranatha! <><
John McKown
Hello,
Does anyone know where to find an example project that creates a SQLite virtual
table module using a web service as the data source? Or if anyone has done
this type of work, please contact me directly.
Thank you,
John Stegeman
ng
Schrodinger's backup: The condition of any backup is unknown until a
restore is attempted.
He's about as useful as a wax frying pan.
Maranatha! <><
John McKown
know where I am."
Computer Science is the only discipline in which we view adding a new wing
to a building as being maintenance -- Jim Horning
Schrodinger's backup: The condition of any backup is unknown until a
restore is attempted.
He's about as useful as a wax frying pan.
Maranatha! <><
John McKown
ul as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
milated, you will be.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
known until a
restore is attempted.
Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
On Thu, Dec 24, 2015 at 10:14 AM, Simon Slavin wrote:
>
> On 24 Dec 2015, at 3:12pm, John McKown
> wrote:
>
> > ?I'm curious as to why. Doing so would, most likely, require rewriting
> the
> > entire table. If you want a SELECT * to get the columns in a particul
er Science is the only discipline in which we view adding a new wing
to a building as being maintenance -- Jim Horning
Schrodinger's backup: The condition of any backup is unknown until a
restore is attempted.
Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
inger's backup: The condition of any backup is unknown until a
restore is attempted.
Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
y backup is unknown until a
restore is attempted.
Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
On Sun, Nov 8, 2015 at 10:36 AM, Simon Slavin wrote:
>
> On 8 Nov 2015, at 4:11pm, John McKown
> wrote:
>
> > I'm not a developer. So I guess that it's my ignorance as to why a
> program
> > would be confused by the string value of "null" or any
Richard
Thanks. That gives me what I would expect.
John Gillespie
sqlite-src-30902T 573 % ./sqldiff z1.db z2.db
ALTER TABLE A ADD COLUMN category;
UPDATE A SET category='' WHERE rowid=1;
UPDATE A SET category='' WHERE rowid=2;
UPDATE A SET category=''
thought of plugh as well,
but a search turned up a article by a Mike Plugh.
I also won't disclose the strange problem I saw for Mr. John Doe and his
wife Jane in some code.
On Nov 8, 2015 04:56, "Simon Slavin" wrote:
> An article by Christopher Null on how database programmers
(2,''), (3,'');
sqlite> alter table A add category text;
sqlite> update A set category='';
sqlite> select * from A;
1||
2||
3||
sqlite> .exit
Great database - ergo great development team!
John Gillespie
On Thu, Oct 22, 2015 at 09:27:43PM +0100, Simon Slavin wrote:
> Financial software frequently handles all currency amounts as pence or
> cents for the reasons you've just found out.
Most financial processing is done on mainframes which have had fixed point
decimal types (in hardware) since the e
e are. Futile, resistance is, yes. Assimilated, you will be.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
--
Schrodinger's backup: The condition of any backup is unknown until a
restore is attempted.
Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
AS (SELECT 1) INSERT INTO t(x) SELECT * FROM p;
sqlite> select * from t;
1
sqlite>
?
--
Schrodinger's backup: The condition of any backup is unknown until a
restore is attempted.
Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.
He's about as useful as
will be.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
rs
>
--
Schrodinger's backup: The condition of any backup is unknown until a
restore is attempted.
Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
101 - 200 of 2794 matches
Mail list logo