You can create an index on a view. See
Forum: Visual FoxPro Category: Databases,Tables, Views, Indexing and SQL syntax Title: Using a view Thread #585210 Message #585210
for info creating the index.

Then just something like :

SELECT MyView
SET ORDER TO MyIndex
THISFORM.REFRESH

in the click event of the grids header.

hth


>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