Re: [sqlite] SELECT issue with SQLite 3.6.10

2009-01-28 Thread KurDtE
it's difficult to remove. Igor Tandetnik ___ 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

[sqlite] SELECT issue with SQLite 3.6.10

2009-01-27 Thread KurDtE
in the view. I now get this error : GENERAL.ID : no such column. I think it gets confused with the dot, how to make the query understand it as column name, and not table name + column name ? Thanks for help, Regards, Anthony -- View this message in context: http://www.nabble.com/SELECT-issue

Re: [sqlite] SELECT issue with SQLite 3.6.10

2009-01-27 Thread D. Richard Hipp
On Jan 27, 2009, at 5:24 AM, KurDtE wrote: Dear all, Yesterday I upgraded my SQLite version from version 3.5.9 to 3.6.10, and I now experience an issue while making a SELECT on one of my view : This query was previously working on version 3.5.9 : SELECT [GENERAL.ID] FROM VIEW_GENERAL;

Re: [sqlite] SELECT issue with SQLite 3.6.10

2009-01-27 Thread Fred Williams
of SQLite Database Subject: Re: [sqlite] SELECT issue with SQLite 3.6.10 On Jan 27, 2009, at 5:24 AM, KurDtE wrote: Dear all, Yesterday I upgraded my SQLite version from version 3.5.9 to 3.6.10, and I now experience an issue while making a SELECT on one of my view : This query was previously

Re: [sqlite] SELECT issue with SQLite 3.6.10

2009-01-27 Thread D. Richard Hipp
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

Re: [sqlite] SELECT issue with SQLite 3.6.10

2009-01-27 Thread Fred Williams
Subject: Re: [sqlite] SELECT issue with SQLite 3.6.10 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

Re: [sqlite] SELECT issue with SQLite 3.6.10

2009-01-27 Thread KurDtE
...@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

Re: [sqlite] SELECT issue with SQLite 3.6.10

2009-01-27 Thread Noah Hart
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

Re: [sqlite] SELECT issue with SQLite 3.6.10

2009-01-27 Thread Igor Tandetnik
KurDtE kur...@hotmail.com wrote: 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