1) In some headers of my grid I have added click event code to SET ORDER TO the order indicated by the ControlSource of the column I'm in. I do a simple SET ORDER TO followed by a grid.refresh
If I do this with the topmost row of the grid highlighted, it works fine. However, when I have highlighted a row OTHER THAN the topmost, my record pointer changes and I'm no longer on the record that I was at before I did the refresh!
Why is that? The order does indeed change, but is changed IN REFERENCE TO the topmost record in the grid again! My highlight bar remains on the same physical row, but NOT on the record I was at when I did the refresh. It's as if the refresh is first moving to the record at the top of the grid and then updating the actual look. HELP!
2) I now have to call the above proc in all of my header.click events when I am defining what fields to be used in the grid. If I opt to see ALL the columns/fields how can I indicate an action to take upon clicking ANY of the headers?
Thanx,
Joe Pirola