column sort

[Yohn]

Hy!
I'm having a table that must be sort alphabetically when I click on some field in that table. How do I do that?

Thanks!

 

[dayv2005]

assuming that you are refering to column sorting in a browser?

once your browser i all set you go to the browser properties and click on the advanced button. While in there chck column searching.

Now go to the browsers triggers and add a start-search trigger.

make this look like this.

DO:
    DEFINE VARIABLE hQueryHandle AS HANDLE           NO-UNDO.
    DEFINE VARIABLE hSortColumn  AS WIDGET-HANDLE.  
    DEFINE VARIABLE sortOrder  AS char.  
    IF sortorder = "DESCENDING" THEN
        SortOrder = "".
    ELSE
        SortOrder = "DESCENDING".
    hSortColumn = BROWSE br-LoadScorecard:CURRENT-COLUMN.
    hQueryHandle = BROWSE br-LoadScorecard:QUERY.
    hQueryHandle:QUERY-CLOSE().
    hQueryHandle:QUERY-PREPARE("FOR EACH ttLoadScorecard NO-LOCK BY " + hSortColumn:NAME + " " + SortOrder).
    hQueryHandle:QUERY-OPEN().
END.

 

[kartikeya.sharm]

nice dear...

 

[trmrahim]

Its very useful..Thank You dayv2005 ............

 

[snooker]

very very usefull code. thanks..

 

[sachin4gl]

hello friends ,
i had created a browse using QAd.net browse maintenance program .
In this browse my group by option is not enable .
can you suggest me how can i enable my "group by" feature .


regards,
Sachin