🚀 go-pugleaf

You can not do that - OLEDB providers method SetRange but ADO does not. Also
indeces work only on server-side cursor.

You may add WHERE to your query and specify needed diapason.

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

"Kim Utley" <kim@simsware.com> �������/�������� � �������� ���������:
news:408fbb65$1@newsgroups.borland.com...
> Hello All!
>
> I have Microsoft access tables where each record has a date/time stamp
when
> it was last modified. In addition my primary key does not contain this
value
> however, I do have an index called DateTimeStampIx which only contains
this
> value. I perform the following:
>
> TADOTable->Active    = false;
> TADOTable->IndexName    = "DateTimeStampIx";
> TADOTable->Active    = true;
>
> Now my question is how do I only obtain records with a date/time stamp
> greater than a specified value (e.g., greater than "01/01/2004 12:00AM")?
> The Locate() and Seek() methods appear to want an equal operator with or
> without a partial match..
>
> Kindest Regards,
>
>
> Kim L. Utley
>
>