Another ADOTable Index question

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

Article #4285

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

#4285

From: David Nash
Date: Wed, 30 Jan 2002 19:19

19 lines
1527 bytes

Hi

I've got a similar problem to 'szumi', below; trying to change the order of
data in a grid by changing to a non primary-key index.   I'm using an Access
2000 database.

I've tried the following code

   DataModulePIA->ADOTownTable->Close();
   DataModulePIA->ADOTownTable->IndexName = String("TownName");
   DataModulePIA->ADOTownTable->Open();
   DataModulePIA->ADOTownTable->First();
// The above doesn't seem to have any effect.
// I tried the sort method, but I'm not sure if I have the correct syntax:-
   DataModulePIA->ADOTownTable->Sort="TownName";  // giving runtime error

Any help would be much appreciated

David Nash

Technical Details

Message-ID: <3c5845e2_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newshub2.rdc1.sfba.home.com!news.home.com!newsfeed.mesh.ad.jp!uunet!osa.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,a645144a1c97fd95,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-01-30 11:17:30 PST
From: "David Nash" <nashcom@btinternet.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Another ADOTable Index question
Date: Wed, 30 Jan 2002 19:19:09 -0000
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 213.122.167.188
Message-ID: <3c5845e2_1@dnews>
X-Trace: dnews 1012418018 213.122.167.188 (30 Jan 2002 11:13:38 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newshub2.rdc1.sfba.home.com!news.home.com!newsfeed.mesh.ad.jp!uunet!osa.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews