>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
I think this sort of problem (can't create temporary indices) appears with table buffering (5, if you use optimistic buffering). Try row buffering (3) instead.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)