[sqlite] SQLite Update With CTE

= 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 ___ sqlite-users mailing

Re: [sqlite] syntax error near AS

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

Re: [sqlite] syntax error near AS

ror message if they are 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 Subjec

Re: [sqlite] syntax error near 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

Re: [sqlite] syntax error near AS

ger an 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

Re: [sqlite] syntax error near AS

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

Re: [sqlite] syntax error near 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

Re: [sqlite] syntax error near AS

ror message if they are 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 Subjec

Re: [sqlite] syntax error near AS

ger an 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-users@mailingl

[sqlite] syntax error near AS

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_

Re: [sqlite] [OT] UTF8-BOM and text encoding detection (was: UTF8-BOM not disregarded in CSV import)

i/Byte_addressing), there was at least one machine (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

Re: [sqlite] [OT] UTF8-BOM and text encoding detection (was: UTF8-BOM not disregarded in CSV import)

on. https://www.ibm.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

Re: [sqlite] 3.19.3 README.md Doc bug

gt;# above creates directory ./sqlite x>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 th

Re: [sqlite] feature req: PLEASE why the heck COMMENT fields are not supporte in years!!

erican government went to IBM 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

Re: [sqlite] FTS5 performance problem.

unt() from PostFTS where PostFTS match ?1 ThreadID:?2; -- http://fresh.flatassembler.net http://asm32.info John Found <johnfo...@asm32.info> ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] FTS5 performance problem.

? Or such behavior is normal and expected. -- http://fresh.flatassembler.net http://asm32.info John Found <johnfo...@asm32.info> ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/

Re: [sqlite] Request for ISO Week in strftime()

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 li...@jspect.fastmail.fm

Re: [sqlite] Thread notification for new record in a table.

On Tue, 2 May 2017 09:38:30 +0200 Olivier Mascia <o...@integral.be> wrote: > > Le 2 mai 2017 à 09:00, John Found <johnfo...@asm32.info> a écrit : > > > > What is the best way (less CPU consuming) to put a thread in sleep and wake > > it up when new reco

[sqlite] Thread notification for new record in a table.

want both. :) -- http://fresh.flatassembler.net http://asm32.info John Found <johnfo...@asm32.info> ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Best practices for huge batch inserts with WAL?

n. If 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:/

Re: [sqlite] Performances and Foreign keys

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 <johnfo...@asm32.info> ___ sqlite-users mailing list sqlite-users@mai

Re: [sqlite] Which pragmas are persistent?

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 <to...@acm.org> wrote: > -Original Message- From: no...@null.net > >> What would be useful (at least via the shell CLI) is a "

[sqlite] confused getting started

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

Re: [sqlite] thousand separator for printing large numbers

ne user at a time" to "multiple 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

Re: [sqlite] SQLite Query truncating String column at 255 chars long

be more "straight forward" 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

Re: [sqlite] SQLite Query truncating String column at 255 chars long

1112 sqlite> select length(testtext) from testit; 401 sqlite> ​ -- There’s no obfuscated Perl contest because it’s pointless. —Jeff Polk Maranatha! <>< John McKown ___ sqli

Re: [sqlite] [OT] mySQL ORDER BY clause in Views

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

[sqlite] Tcl Interface - minor docs suggestion

ored 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 ___ sqlite-users m

Re: [sqlite] 3rd Call For Papers - 23rd Annual Tcl/Tk Conference (Tcl'2016)

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

Re: [sqlite] "Responsive" website revamp at www.sqlite.org

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.

Re: [sqlite] locating a minimum in SQLite 2

from info where price=(select min(price) from info) limit 1; 1|a sqlite> ​ -- 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

Re: [sqlite] Datatype for prices (1,500)

Point. https://en.wikipedia.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.o

Re: [sqlite] creating a table

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

Re: [sqlite] creating a table

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, John R

Re: [sqlite] creating a table

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

Re: [sqlite] creating a 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

[sqlite] creating a table

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

Re: [sqlite] Command line not accepting multi-line statements.

Thanks, that worked. John Gillespie On 8 November 2016 at 14:30, Richard Hipp <d...@sqlite.org> wrote: > On 11/8/16, John G <rjkgilles...@gmail.com> wrote: > > I normally use the 3.8.8.3 supplied with MacOS El Capitan. > > I downloaded version 3.15.1 from the

[sqlite] Command line not accepting multi-line statements.

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

[sqlite] Adding comments to a ticket

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 ___ sqlite-users

Re: [sqlite] [System.Data.SQLite] Using sqlite3.dll instead of Interop.dll - what's the trade-off?

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 ba

Re: [sqlite] .mode column .width .separator

ppears, 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

Re: [sqlite] Virtual table

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 allows attachi

[sqlite] [System.Data.SQLite] Using sqlite3.dll instead of Interop.dll - what's the trade-off?

at 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.Interop.d

Re: [sqlite] Problem with rename table

Thanks Scott for that explanation. John On 11/09/2016 01:27, Scott Robison wrote: On Sep 10, 2016 2:54 AM, "John McMahon" <li...@jspect.fastmail.fm> wrote: On 08/09/2016 10:09, Bob McFarlane wrote: Please reply if you sent this. Thanks. Hmm, looks like a fishing exer

Re: [sqlite] Problem with rename table

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

Re: [sqlite] AS being optional

sqlite-users > -- 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

Re: [sqlite] 64-bit SQLite3.exe

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

Re: [sqlite] Missing source code in 3.14 release

ll fossil checkout version-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 ___ s

Re: [sqlite] Using SQLite without SQL.

On Tue, 26 Jul 2016 21:52:26 +0100 Simon Slavin <slav...@bigfraud.org> wrote: > > On 26 Jul 2016, at 9:29pm, John Found <johnfo...@asm32.info> wrote: > > > Is it possible to use SQLite, making queries directly in the internal > > virtual machine language, inste

Re: [sqlite] Using SQLite without SQL.

On Tue, 26 Jul 2016 16:40:07 -0400 Richard Hipp <d...@sqlite.org> wrote: > On 7/26/16, John Found <johnfo...@asm32.info> wrote: > > Is it possible to use SQLite, making queries directly in the internal > > virtual machine language, instead of SQL? > > No. Why

[sqlite] Using SQLite without SQL.

://fresh.flatassembler.net http://asm32.info John Found <johnfo...@asm32.info> ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] a couple of pre-initial questions

, 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

Re: [sqlite] Locking semantics are broken?

"not reliable". Isn't it? -- http://fresh.flatassembler.net http://asm32.info John Found <johnfo...@asm32.info> ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Correct, best, or generally accepted database structure for groups of things

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 "Star Nomad&qu

Re: [sqlite] Trouble coding conditional UNIQUE

;I think you're mistaking the word optimistic for inept." "They've got a similar ring to my ear." From "Star Nomad" by Lindsay Buroker: Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Managing SQLite indices.

hat is 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 <johnfo...@asm32.info> ___ sqlite-users mailing list sqlite-users@mailingli

Re: [sqlite] I solved the problem with gridview and database

quot;undeliver" an 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.sqlit

Re: [sqlite] Version of the database

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 <rsm...@rsweb.co

[sqlite] SQL Help: Finding case insensitive 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

[sqlite] Illegal SQL not rejected

t; > 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

[sqlite] Illegal SQL not rejected

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

[sqlite] Illegal SQL not rejected

SUM(A). > > Jann > -- The unfacts, did we have them, are too imprecisely few to warrant our certitude. Maranatha! <>< John McKown

[sqlite] Primary key values can be NULL

ogrammer. ?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

[sqlite] Primary key values can be NULL

application 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

[sqlite] Strange behaviour of select.

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

[sqlite] Strange behaviour of select.

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

[sqlite] Strange behaviour of select.

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 compl

[sqlite] Strange behaviour of select.

at can be the reason for such strange behaviour? -- http://fresh.flatassembler.net http://asm32.info John Found

[sqlite] FTS5 query that to match all rows.

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

[sqlite] FTS5 query that to match all rows.

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

[sqlite] Fwd: odd schema resulting from creating a table out of a join with a subselect

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");

[sqlite] Fwd: odd schema resulting from creating a table out of a join with a subselect

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");

[sqlite] Broken database after experiments with fts.

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

[sqlite] Broken database after experiments with fts.

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

[sqlite] Article about pointer abuse in SQLite

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

[sqlite] attach db limit

ling 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

[sqlite] EBCDIC tester needed

o 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

[sqlite] Virtual Table Example?

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

[sqlite] Efficient relational SELECT

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

[sqlite] Running Sqlite under Linux Terminal Server

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

[sqlite] Function patternCompare() not EBCDIC friendly

as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] whish list for 2016

. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] whish list for 2016

l 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

[sqlite] whish list for 2016

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 particular &g

[sqlite] whish list for 2016

n 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

[sqlite] Problem with accumulating decimal values

chrodinger'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

[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

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

[sqlite] A little light reading

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 variant th

[sqlite] Problem with sqldiff

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='' WHERE rowid=3; On 7 November

[sqlite] A little light reading

gh 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 are idiots. > >

[sqlite] Problem with sqldiff

r table A add category text; sqlite> update A set category='dddd'; sqlite> select * from A; 1|| 2|| 3|| sqlite> .exit Great database - ergo great development team! John Gillespie

[sqlite] Simple Math Question

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

[sqlite] Simple Math Question

ile, 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

[sqlite] Simple Math Question

p: 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

[sqlite] Using CTE with INSERT

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 a wax fry

[sqlite] Order with another sequence

He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] How do i submit a bug?

- 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

[sqlite] get the data anyway no matter what the entry of the second table is existing or not

th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] Fwd: OT: Oracle functions for SQlite

alent collection of Tcl - sqlite functions anywhere? I have my own 'initcap' and 'decode' functions. John Gillespie

<    1   2   3   4   5   6   7   8   9   10   >