Hello!
On Friday 12 March 2010 11:47:40 Ben Harper wrote:
> Is there some recommended workaround that I can use to ensure that I always
> get non-null rowids with every VIEW?
>
> CREATE TABLE one (i32 INTEGER);
> INSERT INTO one VALUES(100);
> INSERT INTO one VALUES(200);
> CREATE VIEW v1 AS SEL
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Simon Slavin
Sent: 12 March 2010 11:54 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] rowid availability from views is inconsistent
On 12 Mar 2010, at 8:47am, Ben Harper wrote:
> Under
On 12 Mar 2010, at 8:47am, Ben Harper wrote:
> Under certain conditions, VIEWs do not have rowid values.
>
> Is there some recommended workaround that I can use to ensure that I always
> get non-null rowids with every VIEW?
>
> CREATE TABLE one (i32 INTEGER);
> INSERT INTO one VALUES(100);
> I
Under certain conditions, VIEWs do not have rowid values.
Is there some recommended workaround that I can use to ensure that I always get
non-null rowids with every VIEW?
CREATE TABLE one (i32 INTEGER);
INSERT INTO one VALUES(100);
INSERT INTO one VALUES(200);
CREATE VIEW v1 AS SELECT * FR
4 matches
Mail list logo
