🚀 go-pugleaf

Hi,

Use rather

TADOTable->IndexFieldNames = "DateTimeStampIx";

//Set the filter condition
TADOTable->Filter="DateTimeStampIx > #01/01/2004 12:00AM#";
TADOTable->Filtered = True;

hope this helps

"Kim Utley" <kim@simsware.com> wrote in message
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
>
>