>Hi!
>
>I use grid whose recordsource is alias from remote view. How I have to create function in the grid.columnX.headerX.DblClick which could sort my data by clicked column.
>
>Thanks
>Eugenijus Rimkus

Considerations, in addition to the replies you already got:

You may want to check whether an index on the desired index expression already exists, and then just SET ORDER TO.

Temp indices have to be erased before doing certain stuff, like transactions, I think.

For character expressions, use indices on upper(expression).

You can also use the active order for incremental search. Use Column.Text1.KeyPress().

With the framework Visual Extend, when I press a key in a column, the framework will a) sort on the column, b) start incremental search. Also, I can sort on more than one column (Ctrl-Click on the second and later columns).

HTH, Hilmar.

Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)