LEVEL clause

  • Thread starter Thread starter mark r
  • Start date Start date
M

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
 
mark r said:
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
Click to expand...

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 said:
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
Click to expand...

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.
Click to expand...


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.
 
Marshall Barton said:
Dirk said:
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
Click to expand...

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.
Click to expand...


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.
Click to expand...

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" wrote
Dirk said:
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.
Click to expand...


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. ;-)
 
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
 
Back
Top