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
