Solved

Sorting DBGrid

Posted on 1997-04-27
1
179 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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

707 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now