Board index » delphi » Add Index to TQuery result set??

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??

 

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