Please supply the SQL TEXT for the TABLE and the VIEW; Noah
-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of KurDtE Sent: Tuesday, January 27, 2009 8:41 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] SELECT issue with SQLite 3.6.10 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-tp21682817p2168908 2.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 CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users