Thanks Joe,
Does it mean that it's the expected behaviour of SQLite ?
Would it be possible for System.Data.SQLite to remove these double
quotes if present, as they are not required any more once you have a C#
string ?
--
Vincent
Le 13/10/12 17:33, Joe Mistachkin a écrit :
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
[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
