In my specific case, I'm using virtual tables to hook up a non-sql data source to SQLite. Wanted to 'quote' column names to avoid issues with a column colliding with an sql keyword rather than avoiding use of strange characters.
MikeN -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Stephen Chrzanowski Sent: Friday, January 23, 2015 1:07 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] System.Data.SQLite - Exception Calling SQLiteModule.DeclareTable In the 8.3 days, I routinely gave directories an underscore as a delimiter for version information, prior to my actually using a version control package. So "game" would be the main thing, and if I wanted to test, "game_1" became the new WIP folder. If I liked what I did, I'd move "game" to "game__1" and rename "game_1" to "game". I even sometimes went so far as adding an extension to a directory, so, "mkdir game.1". LOVED how that screwed some of the DOS toys up when a directory contained an extension. :] On Thu, Jan 22, 2015 at 8:13 PM, Keith Medcalf <[email protected]> wrote: > > 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: [email protected] [mailto:sqlite-users- > >[email protected]] 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:[email protected]] > >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: [email protected] [mailto:sqlite-users- > >[email protected]] On Behalf Of Mike Nicolino > >Sent: Saturday, January 17, 2015 6:17 PM > >To: [email protected] > >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 > >[email protected] > >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >_______________________________________________ > >sqlite-users mailing list > >[email protected] > >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: [email protected] > > > >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 > >[email protected] > >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
