You got it right Igor !
So I have my table GENERAL with a field ID.
I create a view VIEW_GENERAL like this :
CREATE VIEW VIEW_GENERAL AS SELECT GENERAL.ID FROM GENERAL
Note that this is just an example, in my real case, I needed to select
GENERAL.ID instead of ID only because I also do some
KurDtE 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
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
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
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 all
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
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 vie
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
8 matches
Mail list logo