Article View: borland.public.cppbuilder.database.ado
Article #1557Re: Index Search
From: Kim Utley
Date: Fri, 14 May 2004 19:25
Date: Fri, 14 May 2004 19:25
36 lines
1731 bytes
1731 bytes
Nigel, Thanks! That worked. Kindet Regards, Kim "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 > >
Technical Details
Message-ID:
<40a51d76$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!controlnews3.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<408fbb65$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,de2cd043e1b62a25 X-Google-Attributes: gid10698b,public From: "Kim Utley" <kim@simsware.com> Newsgroups: borland.public.cppbuilder.database.ado References: <408fbb65$1@newsgroups.borland.com> Subject: Re: Index Search Date: Fri, 14 May 2004 14:25:36 -0500 Lines: 38 Organization: SIMS, Inc. X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 NNTP-Posting-Host: 65.205.74.2 Message-ID: <40a51d76$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1084562806 65.205.74.2 (14 May 2004 12:26:46 -0700) Path: arc1-ca.pugleaf.net!controlnews3.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail