>On reading through the referenced code, I saw that you were using indexes that were already created to control the displayed order, where I was trying to change the SQL ORDER BY clause. I gave up on my approach, created 3 indexes, and got everything to work fine with SET ORDER TO. As this was my first try at dynamically reordering a local view in a grid, I hand coded it to make sure that I understood what was going on. I'll look at implementing the class code that you referenced later.
Hi Bob,
After using it once, you'll want to use it in other places as well. If not you than your users definetelly wiil ask for it. :)
--sb--