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 St
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:
http://www.sqlite.org/src/info/67bfd59d9
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'),
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 previo
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 e
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
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 it?
>>
>>WITH A AS (
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 newer
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.
___
sqlite-us
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
ab
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
h
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 see
12 matches
Mail list logo