First, thank you both for your help ! I'm getting pretty confused : When I execute the query SELECT "GENERAL.ID" FROM VIEW_GENERAL; on SQLite Administrator (which uses an older version of SQLite than 3.6.10), everything works fine, but when I try the same query with SQLite 3.6.10 on command line, I get :
"GENERAL.ID" "GENERAL.ID" "GENERAL.ID" "GENERAL.ID" "GENERAL.ID" meaning that it processes "GENERAL.ID" as text and not as a column name ... Weird isn't it ? D. Richard Hipp wrote: > > > On Jan 27, 2009, at 10:08 AM, Fred Williams wrote: > >> >> Should not the GENERAL.ID be enclosed in double quotes? Or did I >> misread >> the SQL Standard? > > You can use double-quotes to conform to the SQL standard. But SQLite > also allows some non-standard quoting mechanisms for compatibility > with other database engines. [...] is used by MS SQL Server. `...` > is used by MySQL. > > > D. Richard Hipp > d...@hwaci.com > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/SELECT-issue-with-SQLite-3.6.10-tp21682817p21689082.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
