🚀 go-pugleaf

Also

WideString SqlStr = "..."
AdsCnfHist->CommandText=SqlStr;

without .c_bstr() - you assign one WideString to another.

Your query may not work because there is no space between lines, finally it
looks as:

SELECT * FROM ConfigHistoryWHERE  Active=(SELECT MAX(Active) FROM
ConfigHistory);

//------------------------------------------
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)


"Viatcheslav V. Vassiliev" <support@oledbdirect.com> �������/�������� �
�������� ���������: news:40a3be67$1@newsgroups.borland.com...
> 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
> >
> >
>
>