>Gar,
>
>I would suggest testing to see which is faster, referring to the activerow or reissuing a query. ActiveRow is a property of the grid that should be accessed only whne absolutely no other approach will accomplish the task. ActiveRow accesses cause the grid to review its entire record set, with large tables that can take some serious time and using activerow in the dynamic properties of a column means it is accessed by every visible row in the grid.


Because the record source is a view (small record set) active row is faster than rebuilding query in this particular case. What is faster still (in this case where we give the users to sort on every column in the grid) is to take the suggestion rejected earlier and add include a "recorder" attribute in the view which is updated for every record whenever the user resorts.

If you are not allowing the user to resort then the fastest solution of all is simply to create a view with an order by clause as your record order.