Index Search

Article View: borland.public.cppbuilder.database.ado

Article #1510

Back to borland.public.cppbuilder.database.ado Previous Next

#1510

From: Kim Utley
Date: Wed, 28 Apr 2004 14:10

20 lines
1537 bytes

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: <408fbb65$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!fu-berlin.de!newsfeed.iinet.net.au!newsfeed.iinet.net.au!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,de2cd043e1b62a25,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2004-04-28 07:20:08 PST
From: "Kim Utley" <kim@simsware.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Index Search
Date: Wed, 28 Apr 2004 09:10:57 -0500
Lines: 22
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: <408fbb65$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1083161445 65.205.74.2 (28 Apr 2004 07:10:45 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!fu-berlin.de!newsfeed.iinet.net.au!newsfeed.iinet.net.au!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail