Hi,
I have a local view that I fill a field with a random number. The field is not in the base table and I do not need or want to keep this value. However, I need to order the table by this number. I thought heck just add an index but I get an error message that you can't do that with the tables set to buffering. In the view definition I have it set to order by the random number but how do I tell it to reorder once it is populated?

Thanks
Earl