SQL to count diagram objects on all diagrams in all sub-packages...

[qwerty]

I just tried with SQLQuery and it worked.

a) SQL Basics. INT IS NOT STRING
b) SQL Basics for M$Access. If you use a different SQL it might be ok without the GROUP.

q.

[Geert Bellekens]

try giving your result a name

e.g.
Select Count(*) as totalCount from ...

The error you are seeing is a problem related to XML, not a problem with the SQL

(but you should still leave out the single quotes when dealing with integers even though this syntax error seems to be ignored by the database you are using)

Geert