Probably for the same reason people exceed 8.3 filename limitations on Windows or try to embed non-alphanumeric characters in file/directory names (Including spaces and shell special characters) -- they have been told that they could do so and not told of the problems and difficulties created by doing so.
I cannot fathom why one would use underscores either. In both cases the only rational explanation I can come up with as that these folks are "users" or "coders" and not "programmers" ... --- Theory is when you know everything but nothing works. Practice is when everything works but no one knows why. Sometimes theory and practice are combined: nothing works and no one knows why. >-----Original Message----- >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of Hick Gunter >Sent: Thursday, 22 January, 2015 01:39 >To: 'General Discussion of SQLite Database' >Subject: Re: [sqlite] System.Data.SQLite - Exception Calling >SQLiteModule.DeclareTable > >I have always wondered why people will insist on using human readable >column names (with embedded spaces and special characters) in the >implementation layer (SQL code) instead of the presentation layer (user >interface). The clutter introduced into queries by having to quote the >column names by far outweighs any gain from having "some strange field >name" displayed instead of some_strange_field_name... > >-----Ursprüngliche Nachricht----- >Von: Mike Nicolino [mailto:mike.nicol...@centrify.com] >Gesendet: Donnerstag, 22. Jänner 2015 02:17 >An: General Discussion of SQLite Database >Betreff: Re: [sqlite] System.Data.SQLite - Exception Calling >SQLiteModule.DeclareTable > >Figured this one out. DeclareTable doesn't like any 'quoting' around the >column names in the sql. It works fine with just straight column names. > > >-----Original Message----- >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of Mike Nicolino >Sent: Saturday, January 17, 2015 6:17 PM >To: sqlite-users@sqlite.org >Subject: [sqlite] System.Data.SQLite - Exception Calling >SQLiteModule.DeclareTable > >I'm getting an exception calling SQLiteModule.DeclareTable that seems to >imply the 'create table' sql being passed is invalid: "SQL logic error or >missing database". Yet using that same sql on the same connection as a >create table call succeeds. Reviewing the virtual table docs don't imply >there are restrictions on the create table sql for virtual tables so I'm >at a loss to what's wrong. > >The create table sql (the line breaks here are for readability and not >present in the actual string send to DeclareTable): > >create table xxx( >"Username" text, >"DisplayName" text, >"Email" text, >"LastLogin" integer, >"LastInvite" integer, >"Status" text, >"SourceDs" text, >"Data" text, >"SourceDsLocalized" text >) > >Anyone have any input on what might be wrong? >Thanks! > >_______________________________________________ >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/listinfo/sqlite-users > > >___________________________________________ > Gunter Hick >Software Engineer >Scientific Games International GmbH >FN 157284 a, HG Wien >Klitschgasse 2-4, A-1130 Vienna, Austria >Tel: +43 1 80100 0 >E-Mail: h...@scigames.at > >This communication (including any attachments) is intended for the use of >the intended recipient(s) only and may contain information that is >confidential, privileged or legally protected. Any unauthorized use or >dissemination of this communication is strictly prohibited. If you have >received this communication in error, please immediately notify the >sender by return e-mail message and delete all copies of the original >communication. Thank you for your cooperation. > > >_______________________________________________ >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/listinfo/sqlite-users