🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: DBGRID display order with indexes

#5515
From: Jeffrey D. Warsaw
Date: Fri, 27 Apr 2001 19:14
34 lines
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!dnews
References: <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