Re: [sqlite] System.Data.SQLite - Exception Calling SQLiteModule.DeclareTable
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: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] 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 <kmedc...@dessus.com> 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: 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-us
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 <kmedc...@dessus.com> 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: 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 > > >
Re: [sqlite] System.Data.SQLite - Exception Calling SQLiteModule.DeclareTable
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
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
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
[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
