And if you don't quote the 2nd select it comes out OK. This is 3.6.13: sqlite> SELECT "id" FROM "TESTVIEW"; -- Observe the results here. "id" ---------- test sqlite> SELECT id FROM "TESTVIEW"; -- Observe the results here. id ----------
Presumably a simple bug for the powers-to-be to fix. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems ________________________________________ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Joe Mistachkin [sql...@mistachkin.com] Sent: Saturday, October 13, 2012 10:33 AM To: 'General Discussion of SQLite Database' Subject: EXT :Re: [sqlite] System.Data.SQLite Field Name are surrounded by double quotes for Views Vincent DARON wrote: > > http://pastebin.com/q2m5vJky > The double quotes are coming from the SQLite core native library. Run "sqlite3.exe :memory:" and execute the following commands: .mode columns .headers on CREATE TABLE TEST (id); CREATE VIEW TESTVIEW AS SELECT TEST.id FROM TEST; INSERT INTO TEST (ID) VALUES('test'); SELECT "id" FROM "TEST"; -- Observe the results here. SELECT "id" FROM "TESTVIEW"; -- Observe the results here. -- Joe Mistachkin _______________________________________________ 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