count(*)

Hi all,

I am trying to get a computed count(*) in a query to the GroupNDS table and I am
not able to find the right syntax. I am using MS Query on a Windows2000
Professional full patched box with a RO ODBC driver release on a NW6.5/sp3 eDir
8.7.3.2 single server network.

From the SQL MS Query window...

it works...
SELECT GroupNDS.CN
FROM GroupNDS GroupNDS
WHERE (GroupNDS.NDS_FullName Like '%1stterm4thy%')
ORDER BY GroupNDS.CN

it fails...
SELECT Count(GroupNDS.CN) AS 'Count of CN'
FROM GroupNDS GroupNDS
WHERE (GroupNDS.NDS_FullName Like '%1stterm4thy%')

error message: Expected lexical element not found: <identifier>. It
appears the first time ou execute the query. The second time, MS Query hangs.

I have tried to add a GROUP BY clause as...

SELECT Count(GroupNDS.CN) AS 'Count of CN'
FROM GroupNDS GroupNDS
WHERE (GroupNDS.NDS_FullName Like '%1stterm4thy%')
GROUP BY GroupNDS.CN

but it fails anyway: SQL Queey can't be represented graphically. Continue
anyway? If I hit OK, the previous message appears. As far as I understand, it is
a regular situation as far as this message only states for the need of edition
the query in the edit window from now on. Then, MS Query hangs after showing the
previous Expected lexical element not found: <identifier>.

Please, could you give me a clue? Thanks!

Best regards,

Ricardo

Hi

Got this back from the engineer responsible for the control: 
This is a limitation to the current driver. The driver does not currently
support Count on fields.

Thank you

Susan

Susan Perrin wrote:

> Hi
> 
> Got this back from the engineer responsible for the control: 
> This is a limitation to the current driver. The driver does not
> currently support Count on fields.
> 
> Thank you
> 
> Susan

Thanks, Susan,

In the meantime, I will retrieve data and use any other tool to count.
Of course it could be nice can directly do that with MS Query or any
other software reading the data from eDirectory, but we always can use
a intermediary.

Greetings,