[sqlite] SELECT issue with SQLite 3.6.10

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; where "GENERAL.ID" is the name of a column in the

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

Re: [sqlite] SELECT issue with SQLite 3.6.10

ite3 I use, the column is not named the same ... Well, I fixed the problem pretty easily with a SELECT AS statement, I'm just very surprised that such a big change in the behavior has been processed :) Thank you all, Anthony Igor Tandetnik wrote: > > KurDtE <kur...@hotmail.com>