LEVEL clause

[mark r]

errre Message:

The LEVEL clause includes a reserved word or argument that
is misspelled or missing, or the punctuation is incorrect.



what does this mean? what is wrong with my query?


SELECT DISTINCTROW table.fn1, Count(table.fn1) AS [COUNT
Of table)
FROM table
WHERE (table.fn1="categoryname");
GROUP BY table.fn1

 

[Dirk Goldgar]

errre Message:

The LEVEL clause includes a reserved word or argument that
is misspelled or missing, or the punctuation is incorrect.



what does this mean? what is wrong with my query?


SELECT DISTINCTROW table.fn1, Count(table.fn1) AS [COUNT
Of table)
FROM table
WHERE (table.fn1="categoryname");
GROUP BY table.fn1

I don't see anything wrong with that structure, though I don't know what
purpose the DISTINCTROW keyword serves. But that isn't your actual SQL,
is it? Please post the actual SQL of the quer that is failing.

 

[Marshall Barton]

errre Message:

The LEVEL clause includes a reserved word or argument that
is misspelled or missing, or the punctuation is incorrect.



what does this mean? what is wrong with my query?


SELECT DISTINCTROW table.fn1, Count(table.fn1) AS [COUNT
Of table)
FROM table
WHERE (table.fn1="categoryname");
GROUP BY table.fn1

I don't see anything wrong with that structure, though I don't know what
purpose the DISTINCTROW keyword serves. But that isn't your actual SQL,
is it? Please post the actual SQL of the quer that is failing.

Dirk, markr can't do Copy/Paste because his news reader is
on a different machine than his Access development so
various typos creep in all the time. In this case I see an
extraneous semicolon at the end of the FROM clause.

 

[Dirk Goldgar]

errre Message:

The LEVEL clause includes a reserved word or argument that
is misspelled or missing, or the punctuation is incorrect.



what does this mean? what is wrong with my query?


SELECT DISTINCTROW table.fn1, Count(table.fn1) AS [COUNT
Of table)
FROM table
WHERE (table.fn1="categoryname");
GROUP BY table.fn1

I don't see anything wrong with that structure, though I don't know
what purpose the DISTINCTROW keyword serves. But that isn't your
actual SQL, is it? Please post the actual SQL of the quer that is
failing.

Dirk, markr can't do Copy/Paste because his news reader is
on a different machine than his Access development so
various typos creep in all the time. In this case I see an
extraneous semicolon at the end of the FROM clause.

Good spot, Marsh! I didn't notice that. And I just checked and putting
a semicolon there does indeed cause Access to give the error message
Mark reported. I've never heard of a LEVEL clause before, so I can't
say why this typo is causing Jet to think there's one involved here.

 

[Marshall Barton]

"Marshall Barton" wrote

Good spot, Marsh! I didn't notice that. And I just checked and putting
a semicolon there does indeed cause Access to give the error message
Mark reported. I've never heard of a LEVEL clause before, so I can't
say why this typo is causing Jet to think there's one involved here.

Who knows? It's not in the Help list of SQL reserved words.

Maybe it was part of a new feature that didn't make it into
the final product release. ;-)

 

[mark r]

thanks guys, you hit the "mark" again

that was a stupid slip up to leave in the semi-colon.
I guess I was looking for something more sinister given
the "LEVEL CLAUSE" message

thanks again