Article View: borland.public.cppbuilder.database.ado
Article #5510Re: DBGRID display order with indexes
From: Mark Cashman
Date: Fri, 27 Apr 2001 03:34
Date: Fri, 27 Apr 2001 03:34
20 lines
1675 bytes
1675 bytes
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:
<3AE8E8D6.EBE9971D@temporaldoorway.com>Path:
arc1-ca.pugleaf.net!newsfeed.google.com!sn-xit-03!supernews.com!newsswitch.lcs.mit.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!skynet.be!fr.clara.net!heighliner.fr.clara.net!hub.org!hub.org!PeerFeed.KWeb.on.ca!dnewsReferences:
<3AE88D4E.F0D36F89@CompuServe.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-26 20:40:04 PST Message-ID: <3AE8E8D6.EBE9971D@temporaldoorway.com> Date: Thu, 26 Apr 2001 23:34:47 -0400 From: Mark Cashman <mcashman@temporaldoorway.com> Reply-To: mcashman@temporaldoorway.com X-Mailer: Mozilla 4.77 [en] (Win98; 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> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 24.14.197.193 X-Trace: dnews 988342422 24.14.197.193 (26 Apr 2001 20:33:42 -0700) Lines: 22 Path: arc1-ca.pugleaf.net!newsfeed.google.com!sn-xit-03!supernews.com!newsswitch.lcs.mit.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!skynet.be!fr.clara.net!heighliner.fr.clara.net!hub.org!hub.org!PeerFeed.KWeb.on.ca!dnews