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
Roi
'MCP' Visual FoxPro
In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!