Article View: borland.public.cppbuilder.database.ado
Article #5515Re: DBGRID display order with indexes
From: Jeffrey D. Warsaw
Date: Fri, 27 Apr 2001 19:14
Date: Fri, 27 Apr 2001 19:14
34 lines
2207 bytes
2207 bytes
Mark, thanks for the response, I appreciate it. I'll post a copy in the newsgroup you suggested. I tried setting the IndexName and IndexField properties but that didn't make any difference. I modified the TIndexDefs also to no avail. I read up on indexes in the Interbase documentation and it implied that these indexes are really only useful for selects and that the ascending / descending had to do with the ordering of the select, not display order of the table. Mark Cashman wrote: > Hi, Jeffrey! > > TTable is a BDE component, so you should really ask your question in > borland.public.cppbuilder.database.desktop > > However, my guess is that you need to select the IndexName property in > the TTable component for the index you want used if you haven't done > that. > > If you use a TQuery, you need to use the ORDER BY clause in the SQL > statement. > > ------ > Mark Cashman (TeamB - C++ Builder), creator of The Temporal Doorway at > http://www.temporaldoorway.com > - Original digital art, writing, music and more - > C++ Builder / JBuilder Tips and The C++ Builder Programmer's Webring > (Join us!) > http://www.temporaldoorway.com/programming/index.htm > ------
Technical Details
Message-ID:
<3AE9C52F.921047C2@compuserve.com>Path:
arc1-ca.pugleaf.net!newsfeed.google.com!sn-xit-02!supernews.com!news-x2.support.nl!newsfeed.wirehub.nl!news.tele.dk!193.174.75.178!news-fra1.dfn.de!news-koe1.dfn.de!RRZ.Uni-Koeln.DE!nntp.CS.Uni-Magdeburg.De!PeerFeed.KWeb.on.ca!dnewsReferences:
<3AE88D4E.F0D36F89@CompuServe.Com> <3AE8E8D6.EBE9971D@temporaldoorway.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,1873b4865e742632 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2001-04-27 12:46:53 PST Message-ID: <3AE9C52F.921047C2@compuserve.com> Date: Fri, 27 Apr 2001 15:14:55 -0400 From: "Jeffrey D. Warsaw" <jeffreydwarsaw@compuserve.com> X-Mailer: Mozilla 4.76 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 Newsgroups: borland.public.cppbuilder.database.ado Subject: Re: DBGRID display order with indexes References: <3AE88D4E.F0D36F89@CompuServe.Com> <3AE8E8D6.EBE9971D@temporaldoorway.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 24.3.119.67 X-Trace: dnews 988398897 24.3.119.67 (27 Apr 2001 12:14:57 -0700) Lines: 35 Path: arc1-ca.pugleaf.net!newsfeed.google.com!sn-xit-02!supernews.com!news-x2.support.nl!newsfeed.wirehub.nl!news.tele.dk!193.174.75.178!news-fra1.dfn.de!news-koe1.dfn.de!RRZ.Uni-Koeln.DE!nntp.CS.Uni-Magdeburg.De!PeerFeed.KWeb.on.ca!dnews