Re: [sqlite] Insert with an '

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

Re: [sqlite] sqlite on IBM z/OS Unix

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

Re: [sqlite] Should SQLite distinguish between +0.0 and -0.0 on output?

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

Re: [sqlite] UPDATE database using parameters

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

Re: [sqlite] My 1st C++ SQLite3 program

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

Re: [sqlite] Getting number of rows with NULL

> 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

Re: [sqlite] Is there a performance difference between COUNT(*) and COUNT(name)

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

Re: [sqlite] Wanting to return REAL as formatted TEXT

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

[sqlite] make install tries to update /usr/share/tcl8.6 regardless of --prefix= value

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

Re: [sqlite] Many ML emails going to GMail's SPAM

> 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

Re: [sqlite] Emulate right-join

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

Re: [sqlite] random value get re-generated too often in SQLite

0 0 000 920225462863128947|920225462863128947 -723158119245037038|-723158119245037038 ​Hope this at least explains what is happening. I don't know if this is "correct" or not.​ -- I have a theory that it's impossible to prove anything, but I ca

Re: [sqlite] values ?

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

Re: [sqlite] Move to Github!!?

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

Re: [sqlite] Move to Github!!?

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

Re: [sqlite] C++ compiler

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

Re: [sqlite] UTF8 and NUL

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

Re: [sqlite] Easiest way to get day of week as a string (not a number)?

__ > 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

Re: [sqlite] printf() problem padding multi-byte UTF-8 code points

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

Re: [sqlite] Window functions?

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/

[sqlite] "missing" sqlite3 invocation option?

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 _

[sqlite] SQLite queries

that nothing is impossible: Ask him to dribble a football. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] SQLite queries

define "office pool". :] > > -- If someone tell you that nothing is impossible: Ask him to dribble a football. 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

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 thereof. I do understand looking for a string of length 0. If I were to want a special name for Some purpose, I'd likely use xyzzy. I thought of plugh as well, b

[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

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

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

[sqlite] How do i submit a bug?

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

[sqlite] Order with another sequence

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

[sqlite] Simple Math Question

-- 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] Simple Math Question

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

[sqlite] Does PRIMARY KEY imply NOT NULL?

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] BEGINNER - Transactions in shell script

. 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] Feedback request: JSON support in SQLite

lated, 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] sqlite3 file as database

> -- > Cheers -- Tim > > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > -- 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] I don't understand how to use NOT EXISTS

though SQLite also has the function sum() it does not produce > the same result to total() when no lines satisfy the WHERE clause. Sorting > out the possibilities is more complicated. > > Simon. > -- 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] I don't understand how to use NOT EXISTS

Very good! I'll keep that one. On Tue, Sep 15, 2015 at 1:26 PM, Igor Tandetnik wrote: > On 9/15/2015 2:04 PM, John McKown wrote: > >> sqlite> select count(a) from x; >> > > Better still: > > select exists (select 1 from x); > > The difference is th

[sqlite] Handling the whole select query from an index

__ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- 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] Handling the whole select query from an index

'm really curious about it.? > > Rob. > > -- 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] Handling the whole select query from an index

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

[sqlite] Handling the whole select query from an index

On Thu, Sep 17, 2015 at 9:41 AM, R.Smith wrote: > > > On 2015-09-17 02:22 PM, Richard Hipp wrote: > >> On 9/17/15, John McKown wrote: >> >>> Well, this may be a heretical answer. >>> >> Yes, it is. >> >> ?? ?? > (11) This forum

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

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

[sqlite] Primary key values can be NULL

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

[sqlite] Primary key values can be NULL

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

[sqlite] Illegal SQL not rejected

n the SUM(A). > > Jann > -- 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

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

[sqlite] Efficient relational SELECT

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

[sqlite] EBCDIC tester needed

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

[sqlite] Running Sqlite under Linux Terminal Server

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

[sqlite] attach db limit

-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

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

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

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

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

Re: [sqlite] Trouble coding conditional UNIQUE

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

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

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

Re: [sqlite] Missing source code in 3.14 release

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

Re: [sqlite] 64-bit SQLite3.exe

; 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

Re: [sqlite] AS being optional

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

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

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

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

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

Re: [sqlite] locating a minimum in SQLite 2

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

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 are returned in seemingly random order. > >

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

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

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

; 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] thousand separator for printing large numbers

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

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

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

Re: [sqlite] 3.19.3 README.md Doc bug

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

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

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] [OT] UTF8-BOM and text encoding detection (was: UTF8-BOM not disregarded in CSV import)

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

Re: [sqlite] SQlite3 Query Format for Export

___ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listi

Re: [sqlite] What this function returns?

ng int". As best as I can find. Personally, I would use the sqlite3 supplied name and let Dr. Hipp's code resolve it to the proper declaration based on the compiler being used. -- This is clearly another case of too many mad scientists, and not enough hunchbacks. Maranatha! <>< John Mc

Re: [sqlite] What this function returns?

Ah, found it. http://msdn.microsoft.com/en-us/library/s3f49ktz.aspx __int64, unsigned __int64, long long, unsigned long long, -- > This is clearly another case of too many mad scientists, and not enough > hunchbacks. > > Maranatha! <>< > John McKown > -- This is

Re: [sqlite] How to get data between two dates in SQLite with C#?

___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- This is clearly another case of too many mad scientists, and not enough hunchbacks. Maranatha! <>< John McKown _

Re: [sqlite] Mutally dependent JOIN clauses

layed. Without the IFNULL, I think that NULL+1 would equal NULL, not 1. I don't know if the OP wants this type of row or now. I would guess that he does because I think that was his reason for trying a LEFT JOIN. -- Wasn't there something about a PASCAL program

Re: [sqlite] SELECTing from another SELECT

equal sign. That is: SELECT * FROM A WHERE projid IN (SELECT projid FROM B WHERE ptask = 'a'); = is for comparing a single value. IN is used for comparing against a set of values. -- Wasn't there something about a PASCAL programmer knowing the value of everything and the Wirth of nothing? Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Proposed enhancement to the sqlite3.exe command-line shell

deae4a > > > -- > D. Richard Hipp > d...@sqlite.org > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Wasn't there something about a PASCAL programmer

Re: [sqlite] Bug in division?

gt; ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- There is nothing more pleasant than traveling and meeting new people! Genghis Khan Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Fwd: Send parameter from batch file to sqlite

more pleasant than traveling and meeting new people! Genghis Khan Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL Join question

s.CustomerName, Orders.OrderID from Orders INNER JOIN Customers on Customers.CustomerID=orders.CustomerID order by Customers.CustomerName; But INNER JOIN is basically commutative, like addition, so both should result in the same result table. -- There is nothing more pleasant than travelin

Re: [sqlite] SQL Join question

t; to compare the table with itself properly. -- There is nothing more pleasant than traveling and meeting new people! Genghis Khan Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite Database Browser v3.3.0 released

uzzy-fish.com/wordpress-he/archives/74 Komic: http://thekamics.thecomicseries.com/comics/517/ Book: "Revenge of the Fluffy Bunnies" by Craig Shaw Gardner http://books.google.com/books/about/Revenge_of_the_Fluffy_Bunnies.html > > + Justin -- There is nothing more pleasant th

Re: [sqlite] Sorting by month with two dates input

'm no expert and may be wrong on this. Unfortunately, I do not have any data to test the above to try to fix any problems such as syntax errors. Or even to verify that I'm even close to correct. But I do hope that it was of some help to you. -- There is nothing more pleasant than traveling and meeting new people! Genghis Khan Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Index on expressions

I had never heard of MERGE before, but the Oracle documentation on them, and the example, look interesting. -- There is nothing more pleasant than traveling and meeting new people! Genghis Khan Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] pls dont send so many message - once a month is enough

rote: > -- > בברכה, > רפי טוביה > 2570401 052 > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- There is nothing more pleasant than traveling and meeting new people! Genghis Khan Maranatha! <>

Re: [sqlite] What if OpenDocument were built atop SQLite?

nt than traveling and meeting new people! Genghis Khan Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What if OpenDocument were built atop SQLite?

of "urifield", inspect the first portion for the scheme, load the proper library and then pass the URI as a string value to that routine. Of course, this is getting fairly involved. And what is done if such a library does not exist? Error out the entire SELECT? Return a NULL?

Re: [sqlite] What if OpenDocument were built atop SQLite?

to get the number of lines of code in each of those. c == 45,322 lines cpp == 4,600 lines cxx == 5,162,525 java == 616,578 lines So C++ "wins" by about a 3:1 ratio of number of files and 10:1 ratio in terms of lines of code over Java. On Tue, Sep 9, 2014 at 6:58 PM, wrote: > On 2014

Re: [sqlite] pls dont send so many message - once a month is enough

On Fri, Sep 12, 2014 at 1:16 AM, Larry Brasfield wrote: > John McKown writes: > >> The first option is to totally disable getting any emails at all. This >> is often called NOMAIL mode. If you decide to do that, then you can, >> at your convenience, go to this page: &g

Re: [sqlite] SET (x,y) = (x1,y1)?

implemented — the source must be a list of independent expressions. I would like the SET of multiple fields in a single UPDATE command, like what worked in the above transcript. -- There is nothing more pleasant than traveling and meeting new people! Genghis Khan Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Create join and add unique column

b.col3) AS joinTable ORDER BY col1; That may well not work. I don't have anything around to try it on. And, at 06:23 local time, with insufficient caffeine intake, that is the best that I can do so far. -- There is nothing more pleasant than traveling and meeting new people! Genghis Khan

Re: [sqlite] I'm trying to figure out how to ...

so, the row-by-row access wherein you think you are "stepping through" a > result set is an illusion which is created by the technological limitations > resulting from adapting relational and set operations to the unfortunately > linear basis of human procedural implementation of the technology. > > See: http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor for simple > examples. There are certainly lots of others. > > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- There is nothing more pleasant than traveling and meeting new people! Genghis Khan Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] An order by problem, maybe a bug?

k Nielsen > Hayden" under H, whereas you should find him under N. > This is an interesting problem. Which the Unicode people addressed with the "non-breaking space" character of U+00A0. Of course, entering this particular space character is not as simple as just hitting

Re: [sqlite] Please fix the EBCDIC support

SQLite team, >> compile of sqlite3 v3.8.6 amalgamation failed on zOS 2.1 with err CCN3045 >> undeclared identifier sqlite3CtypeMap in function >> sqlite3_compileoption_used. I notice that this was raised previously to the >> mailing list by John McKown. Please consider adding t

Re: [sqlite] libsqlfs - a file system in a SQLite database

tion > data or preferences." > > Simon. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- There is nothing more pleasant than traveli

[sqlite] Submit patch?

I read the web site, but just didn't see a way to submit a bug-fix type patch. The patch only affects an EBCDIC based system. Which is what I am running on at work. I was very impressed that the code was already EBCDIC aware. ___ sqlite-users mailing list

Re: [sqlite] Submit patch?

On Mon, Aug 12, 2013 at 10:21 PM, Richard Hipp wrote: > On Mon, Aug 12, 2013 at 10:43 PM, John McKown > wrote: > > > I read the web site, but just didn't see a way to submit a bug-fix type > > patch. The patch only affects an EBCDIC based system. Which is what I am >

Re: [sqlite] Group by in sqlite 3.8 works a little differently depending on the spaces at the end

I just wonder why all this time this > seems like existed and never noticed. On the other side, mysql of a > some old version also showed a single result > > Max > ___ > sqlite-users mailing list > sqlite-

[sqlite] curious: Why no "shared library" or DLL?

entered in Morse code. Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] curious: Why no "shared library" or DLL?

e compile error which was simple to fix. On Fri, Aug 30, 2013 at 8:18 AM, Tristan Van Berkom wrote: > On Fri, 2013-08-30 at 08:11 -0500, John McKown wrote: > > I know that sqlite is designed as an "embedded" SQL engine. But I am > > curious if there is a specific reason to

  1   2   >