On Tue, 12 Mar 2013 19:57:26 +
Simon Slavin wrote:
> > Is my rewrite the same as the original?
>
> No. You can't use this construction:
>
> > INNER JOIN (Categories INNER JOIN Object_Categories ON
> > "Categories"."Category_ID"="Object_Categories"."Category_ID")
>
> The parser expects a t
On 12 Mar 2013, at 9:12pm, ven...@intouchmi.com wrote:
> The first select was the one that I retrieved from the MS Access DB. That
> one does NOT work in SQLite. Thanks for explaining why it wasn't acceptable
> by SQLite.
You're welcome.
> It was the second select, which I rewrote, that I w
Simon,
The first select was the one that I retrieved from the MS Access DB. That one
does NOT work in SQLite. Thanks for explaining why it wasn't acceptable by
SQLite.
It was the second select, which I rewrote, that I was asking about. That one
is acceptable by SQLite. My question was if t
On 12 Mar 2013, at 7:24pm, ven...@intouchmi.com wrote:
> Is my rewrite the same as the original?
No. You can't use this construction:
> INNER JOIN (Categories INNER JOIN Object_Categories ON
> "Categories"."Category_ID"="Object_Categories"."Category_ID")
The parser expects a table name immed
As a follow up, what I meant to ask is why it doesn't work.
I rewrote the original select:
SELECT "Categories"."Category_Name", "Strings"."Long_Text",
"Units"."Long_Units", "Limits"."Lower_Limit", "Limits"."Upper_Limit"
FROM Objects INNER JOIN (Categories INNER JOIN Object_Categories ON
"Cat
Dominique,
Thanks for your response and for breaking down the select into manageable
pieces!
According to the limits info, there should be no problem with the # of terms in
that select statement (< 500).
There are hundreds of these predefined queries that I am extracting out of the
MS access
I'm no expert, but I think your problem comes from the excessive
parentheses you are using.
Below's a little experiment that reproduces your syntax, with its error,
and provides an alternative simpler syntax that works. --DD
C:\Users\DDevienne>sqlite3
SQLite version 3.7.15.2 2013-01-09 11:53:05
E
Hello,
Using sqlite3, I entered this create view statement:
CREATE VIEW IF NOT EXISTS "Annies Form" AS
SELECT Categories.Category_Name, Strings.Long_Text, Units.Long_Units,
Limits.Lower_Limit, Limits.Upper_Limit
FROM Objects INNER JOIN (Categories INNER JOIN Object_Categories ON
Categories
8 matches
Mail list logo