>>Agnes,
>>
>>Think the solution is not that difficult
>>
>>You can do as many requeries as you like.
>>The only problem, as far as I can see, is
>
>No No I have a method called THISFORM.REQUERY(). This do all parameters for views, repositioning if neseccary and so one. This one is s p e c i f i c to each and every form. I can not go to all forms and change behaviour of this method.
>
>>
>>

>>index on ...
>>requery()
>>index on ... && adds/creates non struct index
>>

>>
>>but this works
>>

>>index on ..
>>requery()
>>
>>requery()
>>
>>requery()
>>
>>begin transaction
>>

>
>The method using TRANSACTION is inherited and know's nothing about special form's requirements (as views, parameters for views and so on).
>
>>Supposing you only hold one index, ie only the column that is sorted on
>
>This is not common in my forms, some other view like summation will use the 'display' view as source. So there are tags for Mr. Rushmore involved.
>
>But this it's all without sense. I can't creep through forms.
>So all what can be done has to be independend from THISFORM.REQUERY() and
>Methods using TRANSACTION.
>
>The only point I know that I change something is Header's SortIt.
>Requery() is impossible there - don't know to handle the view, no parameters, no nothing.
>
>I have stopped automated searching for views (what means for all) now and will have a look around.
>
>
>Agnes

Agnes,

The point I am trying to make is as follows

you can requery as much as you like, do not see any problem
requery() does not change the index

in your headers SortIt:

if( NewOrder Required )
    if CURSORGETPROP('SourceType')=1 && then have only one index active
        delete tag all
        index on thisfield tag thisfield
    else
        set order to something else
    endif
endif

This should make the changes minimal