Add Index to TQuery result set??

and...@aelhk.com (Anders LEE)

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Add Index to TQuery result set??

I have a TQuery show with a DBGRid to user to pick.
Now I want to allow user to click on clumn heading to change how
reocrds are ordered.

How should I do it??

Re-issuing the SQL command with a different ORDER BY takes long time.

Any suggestion??

H. van der Waa

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Add Index to TQuery result set??

Use QBE query and and indexes after the query has finished or if execution
of the query is short
add order by clause in query definition

GL HJW
Anders LEE heeft geschreven in bericht
<35d52284.5555...@News.hk.super.net>...

Quote

>I have a TQuery show with a DBGRid to user to pick.
>Now I want to allow user to click on clumn heading to change how
>reocrds are ordered.

>How should I do it??

>Re-issuing the SQL command with a different ORDER BY takes long time.

>Any suggestion??

Other Threads

1. Add index to TQuery result set??

2. Chaining TQueries: Querying Paradox TQuery result sets using another TQuery

3. TQuery on TQuery result set??

4. Tquery using the result set of another TQuery?

5. TQuery of a TQuery Result Set

6. TQuery of a TQuery Result Set

7. Working with TQuery Result Set

8. Retrieving a result set with a TQuery

9. Long delay on first update to live TQuery result set

10. Doing a locate on a TQuery result set on MSACCESS table in D3