CJGrid Sort on Column Header ONLY

[erikzcai]

I am probably overlooking an easy way to do this... but here goes...

I would like my cCJGrid and the related grid Db classes to sort ONLY when clicking on the column headers. I achieved this with the old dbList and I think I did it with the dbGrid.

I noticed that when the user changes columns (i.e. when tabbing across or clicking in the cells within the column) the columns sort. This can be confusing to users when they make the selection.

I have noticed that the code for header sort is executed even if the clicks or tabs are in the cells of the columns and not on the headers themselves.

Any ideas? Or do I need glasses?

Erik

[Allan Greis Eriksen]

Are you sure that you are not using cDbCjGridPromptList instead of a ccjgrid? If it indeed is a cCjGridPromptList or cDbCjGridPromptList you can simply

Set pbAutoOrdering to False

That way it is not sorted when you navigate to the next column but only when you click the header.

[erikzcai]

Thanks Allan. That worked.

Erik