Re: [sqlite] Working with SQLite-Net in Framework 2.0

On 7/11/2014 1:02 AM, Joe Mistachkin wrote: Steve Rogers wrote: Can the two versions exist in a VS 2010 development environment on the same machine? I hope I have clarified that important detail. I'm not sure as I've never tested that setup. I do know that only the setup package for Visual

Re: [sqlite] WITH syntax error

On 07/13/2014 01:24 AM, Staffan Tylen wrote: According to sqlite3 I'm on 3.8.3: SQLite version 3.8.3 2014-02-03 14:04:11 I remember now. There was a bug regarding compound SELECT statements that use CTEs discovered shortly after 3.8.3 was released:

Re: [sqlite] WITH syntax error

SQLite version 3.8.6 2014-07-07 18:03:38 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> .version SQLite 3.8.6 2014-07-07 18:03:38 1cec1e030035e5253fb7ebbdfe5c1a3029e4e29b sqlite> WITH A AS (SELECT 'A'),

Re: [sqlite] WITH syntax error

On 2014/07/12 20:37, Staffan Tylen wrote: Ryan "After your final Select statement, the constructed "WITH" table no longer exists, it's scope is only visible to the select following the declaration, so anything after a UNION is a new select and as such cannot refer to anything inside the

Re: [sqlite] WITH syntax error

Ryan "After your final Select statement, the constructed "WITH" table no longer exists, it's scope is only visible to the select following the declaration, so anything after a UNION is a new select and as such cannot refer to anything inside the previous select's constructs or clauses." This is

Re: [sqlite] WITH syntax error

On 2014/07/12 19:29, Staffan Tylen wrote: The following statement is flagged as invalid, so what's the correct way of coding it? WITH A AS (SELECT 'A'), B AS (SELECT 'B') SELECT * FROM A UNION SELECT * FROM B ; Hi Staffan, What is wrong with it? Depends what you

Re: [sqlite] WITH syntax error

According to sqlite3 I'm on 3.8.3: SQLite version 3.8.3 2014-02-03 14:04:11 On Sat, Jul 12, 2014 at 8:06 PM, Dan Kennedy wrote: > On 07/13/2014 12:29 AM, Staffan Tylen wrote: > >> The following statement is flagged as invalid, so what's the correct way >> of >> coding

Re: [sqlite] WITH syntax error

On 07/13/2014 12:29 AM, Staffan Tylen wrote: The following statement is flagged as invalid, so what's the correct way of coding it? WITH A AS (SELECT 'A'), B AS (SELECT 'B') SELECT * FROM A UNION SELECT * FROM B ; This statement should work in SQLite 3.8.3 or

Re: [sqlite] WITH syntax error

On Jul 12, 2014, at 7:29 PM, Staffan Tylen wrote: > The following statement is flagged as invalid, so what's the correct way of > coding it? Flagged by whom? Invalid how? Either way, from SQLIte point of view, looks legit the way it is.

Re: [sqlite] Questions from a novice - basic browsing of records ina listview.

On 2014/07/12 14:26, - wrote: Hello Ryan, Thanks for your response. I was writing a lengthy reply when I realized that most of what I said in it where repetitions of what I have already said earlier, so I deleted it. To be honest, its well possible that I currently just can't wrap my head

[sqlite] WITH syntax error

The following statement is flagged as invalid, so what's the correct way of coding it? WITH A AS (SELECT 'A'), B AS (SELECT 'B') SELECT * FROM A UNION SELECT * FROM B ; Staffan ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Questions from a novice - basic browsing of records ina listview.

Hello Ryan, Thanks for your response. I was writing a lengthy reply when I realized that most of what I said in it where repetitions of what I have already said earlier, so I deleted it. To be honest, its well possible that I currently just can't wrap my head about the non-strict way SQLite