🚀 go-pugleaf

Try

SELECT TOP 1 * FROM ConfigHistory ORDER BY Active DESC

This should be easer for Access to optimize.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Martin Moeller" <martin.moeller@moema.it> �������/�������� � ��������
���������: news:40a3b5c2$1@newsgroups.borland.com...
> Hi,
>
> I have an MS ACCESS file with a table called ConfigHistory and a column
> called Active of type DATETIME, which is also PRIMARY KEY.
>
> What I want to do is to load in an ADODataSet just the very last record,
> which is the one with the highest DATETIME value.
> Ho do you do it?
>
> This works fine (loads all field specs)
>
>   // Connection is open and set
>   SqlStr="SELECT * FROM ConfigHistory;";
>   AdsCnfHist->CommandText=SqlStr.c_bstr();
>   AdsCnfHist->Open();
>
> But this generates error
>
>   SqlStr="SELECT * FROM ConfigHistory"
>          "WHERE  Active=(SELECT MAX(Active) FROM ConfigHistory);";
>
> Tks & Rgds, Martin
>
>