Access violation creating an ADODataset with nested Subquery

From: David Martindale (dnm_at_scmh.org.uk)
Date: 05/24/04 

Date: 24 May 2004 06:51:51 -0700

When opening a TADODataset to instantiate the fields, I receive an access violations in both ntadortl70.bpl. This is querying SQLServer 2000, using a subquery. The Text of the query (which works on the server itself) is:

SELECT W.WORKSHOPID, W.TITLE, W.LIMIT, (SELECT COUNT(*) FROM DELEGATE D WHERE D.EVENTID = W.EVENTID AND D.WORKSHOPID = W.WORKSHOPID) AS ATTENDANCE
FROM WORKSHOP W WHERE W.EVENTID=:EventID ORDER BY W.TITLE

Is this a known problem?