Solved

Sorting DBGrid

Posted on 1997-04-27
1
204 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
[X]
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
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

Want Experts Exchange at your fingertips?

With Experts Exchange’s latest app release, you can now experience our most recent features, updates, and the same community interface while on-the-go. Download our latest app release at the Android or Apple stores today!

Question has a verified solution.

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

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Suggested Courses
Course of the Month8 days, 14 hours left to enroll

615 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