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
