Sorting DBGrid

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.
roxAsked:
Who is Participating?
 
javiertbConnect With a Mentor Commented:
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
All Courses

From novice to tech pro — start learning today.