ORDER BY not working, in ADO only, not Access

[markphsd]

Hey,

I have A2002, using ADO 2.7.

I have a select statement:

SELECT ProductID, ProductName
FROM tblProducts
ORDER BY ProductName

It doesn't do the order by with a .getrows and ListView object. I get unordered results in the list.

When I put this in an Access query, I get an ordered result.

When I put this query as a bound recordsource for a listbox I get the ordered result.

Any ideas?



Mark P.

http://www.cafecartel.com

Providing Low Cost Powerful Point of Sale Solutions.