Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Sorting DBGrid

Posted on 1997-04-27
1
193 Views
Last Modified: 2010-04-04
I am using TQuery component on my form. Is it possible to change a DBGrid's sorting order as I want. I don't want to use ORDER BY clause in my SQL statement because I am not allwed to edit the Query's result set.
0
Comment
Question by:rox
1 Comment
 
LVL 2

Accepted Solution

by:
javiertb earned 100 total points
ID: 1335735
If you want to have your DbGrid ordered, you'll have to deal with  the dataset one way or another. That you are not allowed to edit the Query's result set doesn't imply that you can't change the query strings to add an 'order by' clause. Other solution it would be using one of those free components (TSortGrid) available at DSP where you can sort by any column but it's not a data aware component, so you'd have to put all your data programatically in it.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question