Unknown Error in Activating ADO Query

From: acabrera (acabrera_at_bca.lacity.org)
Date: 04/28/04 

Date: Tue, 27 Apr 2004 22:52:31 +0000

I am converting our BDE-based Delphi 7 applications to ADO. In one
application, activating the ADO query below resulted to 'UNKNOWN
ERROR':  

    SELECT * FROM ALLPROJWO_V WHERE
      (PROJ_STATUS_CD = 'ACTIVE' OR PROJ_STATUS_CD = 'TEMPOR')
      ORDER BY WO_NBR

I removed the ORDER BY clause and I was able to activate the query.
However, this clause is important and needs to be included.

Thanks.

--- posted by geoForum on http://delphi.newswhat.com