Re: [sqlite] SQL Help

___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! John McKown

Re: [sqlite] PK References One of Two Other Tables

)​; -- ​ While a transcendent vocabulary is laudable, one must be eternally careful so that the calculated objective of communication does not become ensconced in obscurity. In other words, eschew obfuscation. 111,111,111 x 111,111,111 = 12,345,678,987,654,321 Maranatha! John McKown

Re: [sqlite] aggregate functions with DISTINCT

= 12,345,678,987,654,321 Maranatha! John McKown ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite bugreport : unique index causes valid updates to fail

WAD - Working As Designed. -- The temperature of the aqueous content of an unremittingly ogled culinary vessel will not achieve 100 degrees on the Celsius scale. Maranatha! John McKown ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] sqlite bugreport : unique index causes valid updates to fail

on the Celsius scale. Maranatha! John McKown ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] appending the output of a query

. isn't it possible that the result might be a_d_b_c under some circumstance?​ -- D. Richard Hipp d...@sqlite.org -- The temperature of the aqueous content of an unremittingly ogled culinary vessel will not achieve 100 degrees on the Celsius scale. Maranatha! John McKown

Re: [sqlite] Is sqlite thread-safety sufficient for use with Go language ?

culinary vessel will not achieve 100 degrees on the Celsius scale. Maranatha! John McKown ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Please fix the EBCDIC support

any current ASCII users. But that is up to Dr. Hipp to decide. Definitely above my pay grade.​ -- The temperature of the aqueous content of an unremittingly ogled culinary vessel will not achieve 100 degrees on the Celsius scale. Maranatha! John McKown

Re: [sqlite] Please fix the EBCDIC support

closely enough at the code to see if the big-endian (z/OS) vs. little-endian (Intel) storage of integers would also be a problem. -- The temperature of the aqueous content of an unremittingly ogled culinary vessel will not achieve 100 degrees on the Celsius scale. Maranatha! John McKown

Re: [sqlite] Please fix the EBCDIC support

On Thu, Oct 16, 2014 at 9:09 AM, Richard Hipp d...@sqlite.org wrote: On Thu, Oct 16, 2014 at 9:53 AM, John McKown john.archie.mck...@gmail.com wrote: On Wed, Sep 24, 2014 at 9:46 PM, Richard Hipp d...@sqlite.org wrote: Please try the latest version of SQLite on trunk to see if that works

Re: [sqlite] Please fix the EBCDIC support

to the mailing list by John McKown. Please consider adding the necessary fixes to the SQLite code. Unfortunately, we do not have access to a zOS machine (real or virtual) on which to test the changes. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users

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

this particular space character is not as simple as just hitting the space bar. -- 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

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

@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

Re: [sqlite] Create join and add unique column

Maranatha! John McKown ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

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

On Fri, Sep 12, 2014 at 1:16 AM, Larry Brasfield brasfield.la...@gmail.com 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: http

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

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, jus...@postgresql.org wrote: On 2014-09-08 13:07, John McKown wrote: snip Open/Libre Office is Java based

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

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?

if such a library does not exist? Error out the entire SELECT? Return a NULL? It gets very complicated. And I'm sure Dr. Hipp will see more problems and implications that I could ever imagine. -- There is nothing more pleasant than traveling and meeting new people! Genghis Khan Maranatha! John McKown

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

___ 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

Re: [sqlite] Index on expressions

, 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

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

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 than traveling and meeting new people! Genghis Khan Maranatha! John McKown ___ sqlite-users

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

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

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 traveling and meeting new people! Genghis Khan Maranatha! John McKown

Re: [sqlite] SQL Join question

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

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] Bug in division?

-- 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] Proposed enhancement to the sqlite3.exe command-line shell

___ 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 knowing the value of everything and the Wirth of nothing? Maranatha! John McKown

Re: [sqlite] SELECTing from another SELECT

! John McKown ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Mutally dependent JOIN clauses

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 programmer knowing the value of everything and the Wirth of nothing? Maranatha! John McKown

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

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

Re: [sqlite] What this function returns?

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

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 clearly another case of too many mad

Re: [sqlite] SQlite3 Query Format for Export

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

Re: [sqlite] What is wrong with this trigger?

I would expect NULL (empty string) as the result from a max (or any other summary) query which has no rows. Any particular value wouldn't make too much sense to me. Why any particular value? 0 doesn't really make sense. Well no more or less sense than -1 or even -10372 (picked at random). If you

Re: [sqlite] Row Level Locking as in InnoDB

. ___ 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] What is wrong with this trigger?

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

Re: [sqlite] ALTER COLUMN in sqlite

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

Re: [sqlite] ALTER COLUMN in sqlite

PostgreSQL/Oracle/DB2. It gave me things to think about. Which I always enjoy. On Wed, Oct 16, 2013 at 10:02 AM, a.furi...@lqt.it wrote: On Wed, 16 Oct 2013 07:32:08 -0500, John McKown wrote: I can't say for sure, but would somebody want to store 20 million rows in a SQLite data base? Why? I really

Re: [sqlite] ALTER COLUMN in sqlite

pestering me to do something useful. grin/ On Wed, Oct 16, 2013 at 12:32 PM, Jay A. Kreibich j...@kreibi.ch wrote: On Wed, Oct 16, 2013 at 07:32:08AM -0500, John McKown scratched on the wall: I'm not truly against such a thing. But we need to remember the main use for SQLite is to be small, fast

Re: [sqlite] Problem with method numRows() in Sqlite3

. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- As of next week, passwords will be entered in Morse code. Maranatha! John McKown ___ sqlite-users mailing list sqlite

Re: [sqlite] about Khmer unicode with sqlite

...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- As of next week, passwords will be entered in Morse code. Maranatha! John McKown

Re: [sqlite] count from 2 tables

! John McKown ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite port to RTOS

? It will be really helpful if you can provide me with some inputs on these Regards Pratheek -- As of next week, passwords will be entered in Morse code. Maranatha! John McKown ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SQLite port to RTOS

sqlite-users@sqlite.org http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**usershttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- As of next week, passwords will be entered in Morse code. Maranatha! John McKown ___ sqlite-users

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

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?

which was simple to fix. On Fri, Aug 30, 2013 at 8:18 AM, Tristan Van Berkom trista...@openismus.com 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 _not_ have a DLL/shared

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

Thanks to all for the insight. This only came up when somebody asked me if my port would have a JDBC routine. I am not much of a Java person, but it appears that this would need to be a JNI, which appears to require a DLL. I could be wrong on this point too. As I said, I'm not very Java literate.

[sqlite] patch to

. Maranatha! John McKown ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- As of next week, passwords will be entered in Morse code. Maranatha! John McKown ___ sqlite

Re: [sqlite] Submit patch?

at 10:21 PM, Richard Hipp d...@sqlite.org wrote: On Mon, Aug 12, 2013 at 10:43 PM, John McKown john.archie.mck...@gmail.comwrote: 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

[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